24-07-23, 06:44 AM
PHP كود :
SELECT tableno, ISNULL
((SELECT SUM(total)
FROM dbo.Tbl_Cart
WHERE (tableno = dbo.Tbl_Tables.tableno) AND (status LIKE ' قيد الانتظار ')
GROUP BY tableno), 0) AS Bill
FROM dbo.Tbl_Tables