Hi Robert,
If you want to select record from a particular category, just add another and condition to the where clause. Some thing like below:
WHERE Car = 'red' AND CatLinks.LinkID = Links.ID and CatLinks.CategoryID=123
group by LinkID having count > 1
Cheers,
Dat
Programming and creating plugins and templates
Blog
If you want to select record from a particular category, just add another and condition to the where clause. Some thing like below:
Code:
select LinkID, count(*) as count from CatLinks, Links WHERE Car = 'red' AND CatLinks.LinkID = Links.ID and CatLinks.CategoryID=123
group by LinkID having count > 1
Cheers,
Dat
Programming and creating plugins and templates
Blog
