Re: Two databases

Posted in 1996

Bryan Tonnet — 29 Nov 1996 10:39:05 +1100 — source: Informix-list mailing list archive (1991-1998)

In <57ksld$kvk@cssun.mathcs.emory.edu> rrela@dc.uba.ar (Ramiro Rela) writes: >I need the sintaxis for a SELECT statement which uses tables in two >separate databases. Now I have > SELECT * FROM areas, viviendas > WHERE areas.numero = viviendas.numero >but I'll move the table viviendas to another database. >TIA >Ramiro. SELECT * FROM areas, otherdb:viviendas WHERE areas.numero = otherdb:viviendas.numero I guess this assumes you've got Informix Star, or Engine version 6.x or above. Bryan Tonnet batonnet@zeta.org.au