SQL conditional table join help...

Posted in 2000

Topics: SQL Development & Query Writing, Platform-Specific Issues, Versions, Editions & End-of-Life

Bhaskarla, Sunil — Thu, 29 Jun 2000 16:18:15 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi, I want to : Outer join to tblB only if outer join tblA returns something first. (I have to do this in one select statement.) How do I put the above statement into SQL ? IDS 7.30.UC1 HP-UX 10.20 Thanks, Sunil

↪ replying to Bhaskarla, Sunil

Art S. Kagel — Mon, 03 Jul 2000 09:46:59 -0400 — source: Informix-list mailing list archive (1991-1998)

Isn't that the definition of OUTER join? For every row returned from the 'inner' table join a corresponding row from the outer table if it exists, else return a NULL row. If tablA returns no rows what will the outer table (tblB) join to? Art S. Kagel "Bhaskarla, Sunil" wrote: > > Hi, > I want to : > Outer join to tblB only if outer join tblA returns something first. (I have > to do this in one select statement.) > > How do I put the above statement into SQL ? > > IDS 7.30.UC1 > HP-UX 10.20 > > Thanks, > Sunil