> Does
>
> SELECT categories.categoryid, name, COUNT(categoryshops.categoryid) AS
incat
> FROM categories LEFT JOIN categoryshops
> ON categories.categoryid= categoryshops.categoryid
> AND shopid = 937
> GROUP BY categories.categoryid
>
> work?
>
>
>
> Tino
>
> www.interpool-online.de
Ah! Yes, that does work! Thank you very much.
Although, I swear I tried exactly this SQL query myself. I must be going
mad...
Regards,
-------------------------------------------
Basil Hussain (basil.hussain@stripped)
