SQL logic problem

[Anon]

Hi-

I'm doing this in access, but I think the question can be handled in most situations.

say I have two tables with names and addresses and stuff. I want to build a SQL query that pulls the name field from both tables and puts them in the same column so I can build a report using all the names from both tables.

I'm not having much luck - any ideas?

[smarlowe]

How are you matching up these two tables?

Do you want to have all the names from table 1 followed by all the names from table 2, unconnected in any way, or do you have the same names in both tables and want to join the information from the two tables against some "key" column?

To mush two columns one after the other, you can union them, like so (SQL92):

select from table1 union (select from table1);

if the name in each table is the same, you can match up the tables like this:

select * from table1, table2 where table1.name=table2.name;

where name is the column that matches up in each table.

[Anon]

I wanted to do the first option and it worked - thanks for your help - I never did UNIONS before - learn something new everyday!