rooftop — 2013-03-28T05:05:13-04:00 — #1
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:
SELECT 'cats.id', 'cats.name'
But that returns an emtry set and I know that cannot be correct.
Any ideas. Thanks
rajeev13 — 2013-03-28T06:13:50-04:00 — #2
According to your query there must be a result set from the both-table( join ).
check manually is there any id is same or not.
Your query seems no error.
r937 — 2013-03-28T07:11:21-04:00 — #3
look carefully at your ON clause
you are comparing two strings, and they are not equal, so you get an empty result set
now ask yourself why you used strings there
rajeev13 — 2013-03-28T07:22:39-04:00 — #4
i forgot to keep eyes on single quotes.
starlion — 2013-03-28T08:50:13-04:00 — #5
Probably a reason they put ' and ` so far away from each other on the keyboard