Can I SQL-query data from 2 servers at the same time?

["Tom" <tomh@xxxxxxxxx>]

I have two AS400s, one at v4r3 (server43) the other at v5r2 (server52). Each 
has a database called CUSTOMER, in library PROD.  Using SQL, I need to
pull data from both servers and combine the data for display.  I'd rather 
not output the data to a temp file unless absolutely necessary.

Using interactive SQL, I issue the commands CONNECT TO SERVER43 (while on 
the v5r2 system) followed by SELECT * FROM PROD/CUSTOMER, and I see the data 
from the v4r3 system.  While still connected to SERVER43, I tried the 
following command: SELECT * FROM SERVER52/PROD/CUSTOMER but that failed with 
this error:  Relational database SERVER52 not the same as current server 
SERVER43.

Is there any way around this?

Tom