SQL Select from two tables

[Mondeo]

I have two tables with the identical schema.

 

I need a query which will return this

 

SELECT DISTINCT man FROM table1

SELECT DISTINCT man FROM table2

 

i.e. I need all the results from both tables in one query?

 

How do I do it?

 

Thanks

[Nerseus]

In SQL Server, the UNION statement will do this for you. Simply do:

SELECT man FROM table1
UNION
SELECT man FROM table2

 

If you wanted all the names from both tables including duplicates you'd use "UNION ALL" instead of just "UNION"

 

-ners