Open join in SQL?

Posted in 1991

Walt Hultgren {rmy} — Wed, 11 Dec 91 23:00:07 -0500 — source: Informix-list mailing list archive (1991-1998)

Path: emory!swrinde!elroy.jpl.nasa.gov!sdd.hp.com!hp-col!col!judym From: judym@col.hp.com (Judy Miller) Newsgroups: comp.databases.informix Message-ID: <62980004@col.hp.com> Date: 11 Dec 91 21:23:07 GMT Organization: HP Colorado Springs Division How do you do an "open join" in Informix SQL? I have an extract of data in one temp table showing qty_needed for a part/opt. I have a table2 showing the onhandbalances for each part/opt. I want to report rows showing that action is required: if the onhandbalance < qty_needed OR THE PART/OPT IS NOT IN THE TABLE2. Actually, it gets more complicated in that it takes two columns to uniquely identify a part/opt. Granted, if these tables were designed better, it wouldn't be so awkward. Judy