Multiple Databases in SQL (Online 5.07)

Posted in 1997

Tony Marasco — Thu, 09 Oct 1997 11:28:55 -0400 — source: Informix-list mailing list archive (1991-1998)

I read in the Informix book (one paragraph) that it is possible to access multiple tables in different databases. Is this possible in the same SQL statement? If so, how do you code it? I tried something like: SELECT somecol FROM db1.table1, db2.table2 WHERE etc. Thanks! -- Tony Marasco http://www.berksiu.k12.pa.us mailto:tonmar@berksiu.k12.pa.us