homer.favenir
Verified User
hi,
i have a query but it displays only those records with count, and those with no count doesnt display
here is my query
SELECT
tbl_menu.menu_date,
tbl_menu.concessionaire,
tbl_menu.picture,
tbl_menu.meal,
tbl_menu.`type`,
tbl_menu.price,
(tbl_menu.availability - count(tbl_order.`order`)) as 'Available'
FROM
tbl_menu
inner join tbl_order on (tbl_menu.meal = tbl_order.`order`)
Group by
tbl_order.`order`
i have a count(tbl_order.`order`) = 0 but it does not appear.
this query only displays the records when count is not null
what i need is all records should disply even if the count is not null or null.
pls advice.
thanks
i have a query but it displays only those records with count, and those with no count doesnt display
here is my query
SELECT
tbl_menu.menu_date,
tbl_menu.concessionaire,
tbl_menu.picture,
tbl_menu.meal,
tbl_menu.`type`,
tbl_menu.price,
(tbl_menu.availability - count(tbl_order.`order`)) as 'Available'
FROM
tbl_menu
inner join tbl_order on (tbl_menu.meal = tbl_order.`order`)
Group by
tbl_order.`order`
i have a count(tbl_order.`order`) = 0 but it does not appear.
this query only displays the records when count is not null
what i need is all records should disply even if the count is not null or null.
pls advice.
thanks