Simple query question.

  • Thread starter Thread starter Bill Davis
  • Start date Start date
B

Bill Davis

I have 2 database that I need to collect data from for
reporting db1.[currentdata] and db2.[currentdata]. How
can I create a query that will combine the two tables as
though it was one table.
 
Use an Union query. Check the Help file for union query. Looks like:
Select CurrentData
From Db1
Union
Select CurrentData
From Db2;
 
Thanks you..
-----Original Message-----
Use an Union query. Check the Help file for union query. Looks like:
Select CurrentData
From Db1
Union
Select CurrentData
From Db2;

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


I have 2 database that I need to collect data from for
reporting db1.[currentdata] and db2.[currentdata]. How
can I create a query that will combine the two tables as
though it was one table.
Click to expand...


.
Click to expand...
 
Back
Top