This is where LEFT JOIN comes in:
select
folders.folder_name,
folders.folder_id,
count(folder_items.item_id)
from (folders left join folder_items on folders.folder_id =
folder_items.folder_id)
where
folders.folder_type='favourites'
group by folder_name
Basically you need to decide which side yo
Hi All,
I'm trying to select a number of columns from 2 tables using an inner join.
One of the columns I'm selecting is a count and when the count is zero it doesn't
return that row.
I'd like to return all rows, even if the count of one of the columns is zero.
Can somebody show me how to fix my
