how can I join two querys

's Computer Specifications

Hi,

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

Thanks in advance

B Regards
Ajith

's Computer Specifications

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;

"Ajith Nair" wrote:

> Hi,
>
> How can i join two querys to get one set of data.
>
> Thanks in advance
>
> B Regards
> Ajith
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Type mismatch in JOIN expression. (Error 3615) Join data stored asText and Number	excelCPA	Microsoft Access Queries	4	13th Nov 2009 12:47 PM
Querys based on Querys	=?Utf-8?B?R2lsbA==?=	Microsoft Access Queries	7	2nd Sep 2007 07:27 PM
how can I join two querys --- to be precise	Ajith Nair	Microsoft Access	2	7th Sep 2006 01:47 PM
You must join New York Paid To Read !!!!!!! NewYork PTR is online!!! JOIN NOW!!!!!!	ADMIN	Microsoft ASP .NET	1	5th Jun 2006 04:27 PM
Join Queries - can you join two tables with similar records, not an exact match?	John Goodrich	Microsoft Access Queries	1	15th Sep 2004 07:24 AM