Re: SQL conditional table join help...

--- "Bhaskarla, Sunil" <Sunil.Bhaskarla@Eclipsys.com> > 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 Whenever I see, "I have to do this in one select statement." I wonder if it's to settle a bet. As far as 'how' to do it, it might depend on what you're pulling from A and how it relates to B or to the unspecified table you're doing the joins to A and B. == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net