Yes, Sir. That helps. :)
And i have solved another where ...
WHERE Car = 'red' AND CatLinks.LinkID = Links.ID
group by LinkID having count > 1
But how i can ask
Choose all LinkID from CatLinks with more than 1 Cat and one CategoryID of them is '123' ?
And i have solved another where ...
Code:
select LinkID, count(*) as count from CatLinks, Links WHERE Car = 'red' AND CatLinks.LinkID = Links.ID
group by LinkID having count > 1
But how i can ask
Choose all LinkID from CatLinks with more than 1 Cat and one CategoryID of them is '123' ?