sql server new users: help with join? -- sql server new users

help with join?

r
8/25/2005 1:12:31 PM

sql server new users:

I have two tables with the same layout, and I need to join them in a way
that all the records from each table will be "on top" of each other (not
sure how else to word that).

For example:

Table 1 records:

A
B
C

Table 2 records:
1
2
3

I need my output to look like this:

A
B
C
1
2
3

Can this be done?

Re: help with join?

cleo
8/25/2005 5:07:55 PM

Try a Union Query

Select Field1, Field2, Field3 From Table1
Union All Select Field1, Field2, Field3 From Table2;

[quoted text, click to view]