Querying ODBC Tables

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

I have an Access 2003 Database which contains ODBC links to 3 external
(proprietary) databases of the same structure. i.e., all 3 external DBs
have a table called customer. They appear as "linked" tables db1_customer,
db2_customer, db_3customer

1) I want a query that list everything in 3 tables (i.e., if there are 3
records in db1_customer, 7 records in db2_customer and 11 records in
db3_customer), I want a SQL query that pulls back 21 records in total from
all 3 tables). Is this possible in SQL for access? If so, how? (I know I
could use VBA and loop through the 3 recordsets, but wondering if there's a
simply means).

2) Slightly more complicated here. I want to be able to "join" tables
together
joining the customer table with the order table in all 3 databases
i.e.
(db1_customer x db1_order), (db2_customer x db2_order),(db3_customer x
db3_order)
(i.e., the dataset containing the cross join of customer table and order
table from all 3 databases). Is this at all possible? If so, how?
 
Hi Patrick,

Thanks for your posting!

I have noticed that you made another thread in the newsgroup and community
member MGFoster made a great followup. I will monitor that thread instead
of this one to keep the integrity of newsgroup.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
 
Back
Top