return records with zero count

homer.favenir

Verified User
Joined
Feb 19, 2008
Messages
12
Location
manila, philippines
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:D
 
Back
Top