Re: Query question

From: The Magnet <art_at_unsu.com>
Date: Tue, 30 Aug 2011 13:03:24 -0700 (PDT)
Message-ID: <c9f221a4-7853-452f-90f8-dbd7d3beb63e_at_c8g2000prn.googlegroups.com>

On Aug 30, 1:56 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> The Magnet wrote:
> > Hi,
>
> > We have a massive query.  But there is a problem.  One of the
> > subqueries does not return any rows, therefore the entire query
> > returns no rows.  I need to make it is one of the subqueries has no
> > results, then it just gets NULL or 0.  The query is below.   Can
> > someone help?
>
> > Thanks!
>
> That is normally solved with an "outer join".  Check it out.

I'm not sure how I would do this with an outer join, since all of the columns are basically subqueries. If one of the subqueries returns no results, why does the entire query fail? Received on Tue Aug 30 2011 - 15:03:24 CDT