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.

[code=mysql]SELECT OWNER.id, COUNT(*) product_count FROM OWNER
LEFT JOIN PRODUCT ON OWNER.id = PRODUCT.owner_i d
ORDER BY product_count DESC[/code]