I have two tables - cats and manufacturers. Both have primary 'id' fields. I need to merge them and so want to find out how many have the same id.
I've tried this:But that returns an emtry set and I know that cannot be correct.Quote:
SELECT 'cats.id', 'cats.name'
INNER JOIN `manufacturers`
Any ideas. Thanks