how can I join two querys

  • Thread starter Thread starter Ajith Nair
  • Start date Start date
A

Ajith Nair

Hi,

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

Thanks in advance

B Regards
Ajith
 
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;
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can I join two querys --- to be precise 2
How Can I join Two Queries? 3
Can't outer join or append. 2
to give two inner joins and left join in a query. Please give an e 1
Joining two Dsum 1
Outer Join and a two step query 1
How to keep all values from two table 4
To Include All Data 21

Back
Top