Excel SQL help

[A[L]C]

hi all,

I have a number of servers with SQLEXPRESS.

I'd like to be able to pull some data off in to excel from these servers. I am able to connect to, and get the data from each table, however there are two tables with the same columns and I would like to get the data from both of these columns with the same query.

eg Reads_000 and Reads_001

How would I go about doing this?

Thanks
Paul

 

[Pho]

Try this:

SELECT * FROM [Reads_000] UNION SELECT * FROM [Reads_001]

Or to include duplicates:

SELECT * FROM [Reads_000] UNION ALL SELECT * FROM [Reads_001]