How to have each row contain the left joined data that applies to it

[sKunKbad]

I'm trying to get all of my rows to have the category IDs that belong to them, but I'm not doing it right. My query:

 

SELECT l . * , c.id AS category_id
FROM listings l
LEFT JOIN categories c ON l.id = c.id
LIMIT 0 , 30

 

There are only two categories, and four listings. The first two listings have the correct category id in the result row, but the last two listings have NULL. Is there a way to have the category ids in all of the rows?

[kickstart]

Hi

 

If the data is there your SQL should provide what you want.

 

You you post the data on here.

 

However I am not sure you are joining on the correct columns. You are joining on l.id = c.id, just to return c.id as the category id when you could just return l.id and not do the join.

 

All the best

 

Keith