Help with SQL query

brixton

Hello!

I have a DB setup which simplified looks like this:

PRODUCT(id, owner_id)
OWNER(id)

What I want to do is to produce a list of how many products each owner has, and then sort it in some way, all in a single query.

How do I go about this?

Thanks!

mwasif

Use the LEFT JOIN to produce the results e.g.

Expand|Select|Wrap|Line Numbers

 SELECT OWNER.id, COUNT(*) product_count FROM OWNER 

LEFT JOIN PRODUCT ON OWNER.id = PRODUCT.owner_id

ORDER BY product_count DESC

Help with SQL query

re: Help with SQL query

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about