[ic] Query problem with shared database

[Jon Jensen]

On Tue, 3 Jun 2003, Jamie Neil wrote:

> Out of interest, what happens if you do a query that uses two databases with
> different DSNs?

How would you do that? Think through what Interchange is doing. You tell 
it "table=merchandising", so it translates that to a certain DSN, then 
passes the query verbatim to that DSN. If your query makes no sense to 
that database, I'm sure it'll politely tell you, but that's between you 
and the database, and Interchange is just the messenger. :)

Jon