If you have an ODBC driver that allows you to access the AS400 data, you can use Linked Servers to accomplish this task. Check out SQL Books Online or MSDN for the details.
Don Whitehead Developer/DBA INCCRRA Microsoft Certified Professional [EMAIL PROTECTED] -----Original Message----- From: Van den Bossche Eric [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:59 AM To: ActiveServerPages Subject: Slightly OT: Joining 2 tables in 2 databases Hi all, maybe this is OT but I know that the specialist are here so...... I have a table in an AS400 that contains products. I also have a table in an SQL server database that contains the budget of the products in the AS400. Is it possible to link (inner join) the 2 tables to make calculations with the numbers on an ASP page ? Thanks - Eric --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
