how can I join two querys

[Ajith Nair]

Hi,

How can i join two querys to get one set of data.

Thanks in advance

B Regards
Ajith

 

[Guest]

It is called a UNION query. The SQL would look like this --

SELECT Field1, Field2, Field3
FROM Table1
UNION SELECT Field1, Field2, Field3
FROM Table2;