Appending Linked Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two linked tables that contain the same information from two databases
(I know this sounds wierd). It is student information: start date, course,
etc. Both table have the same exact fields. The reason for two seperate
databases (our IT department set this up) is because there are two different
pricing structures for our consortium and non-consortium members.

Okay, my question is: Is there any way that I can put this data into only
ONE table to combine by ONE query? Right now, I have many reports that are
generated from these tables, and I am having to duplicate everything. I
cannot just copy and paste, as these are linked tables.

Any suggestions would be greatly appreciated.
 
1. Combine the two tables and have a consortium member field. Then you can do
calculations based on that.

2. A union query. It would look something like:

Select start date, course, title
From Table1
UNION ALL
Select start date, course, title
From Table2;
 
I am working with tables from 3 databases which connect to 3 different web
applications, so number one is out. I am not comfortable with SQL code. Can
you give me a more specific example? Do I have to put the field names in
brackets?

Thank you!!
 
The simplest way of doing this would be to use an asterisk, i.e.

SELECT *
FROM table_1

UNION ALL

SELECT *

FROM table_2

Put this in the SQL view of a query and save it. If the table field names
are identical and in the same order this should work. It the tables are
large, you may have performance problems.

Good Luck,

Paul
 
Back
Top