Re: SQL conditional table join help...

--- "Art S. Kagel" <kagel@bloomberg.net> > wrote: >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? I tried fishing for more info since the request seems to imply a third table (I want to outer join tableB to what?) and I assumed that there may have just been a miscommunication of what needed to be accomplished. But then, I like to give folks the benefit of the doubt. >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 == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net