Re: Using WHERE with local table

Posted in 1997

GreggD09 — 4 Jan 1997 21:27:03 GMT — source: Informix-list mailing list archive (1991-1998)

select * From database@node1:table where field = (select MAX(field_name) From database@node2:table) this selects from a database on one node and compares to a field in a database on the other node. I don't know if this is what your looking for but I hope it helps Gregg