imstillatwork
IS-IT--Management
here is my simple two tables joined.
Without a subquery (mysql 4.0.16, hosted) how can I coun the links per category?
Thanks, I'm sure r937 will have a deliciously elegant way to make this work
Code:
SELECT
l.id AS lid
,l.title AS ltitle
,c.id AS cid
,c.title AS ctitle
FROM links AS l
LEFT JOIN category AS c
ON c.id = l.category_id
Without a subquery (mysql 4.0.16, hosted) how can I coun the links per category?
Thanks, I'm sure r937 will have a deliciously elegant way to make this work