Simple query on two tables?

[Mr Chris]

Hello,

 

Hopefully an easy one.  Say I want to search two tables for the same thing, where each of the tables has the column 'name' in it:

 

How would I correctly do it, I tried:

 

SELECT *
FROM table1, table2
WHERE table1.name = 'John'
OR table2.name = 'John'

 

But this brings back results for table1 and table2 in a single row, even though the result returned should just be from table2 as that's the only occurrance of John?

 

Thank you

[kickstart]

Hi

 

Use a UNION (or a UNION ALL)

 

SELECT *
FROM table1
WHERE table1.name = 'John'
UNION
SELECT *
FROM table2
WHERE  table2.name = 'John'

 

All the best

 

Keith

[Mr Chris]

Thank you for your help