Re: Query question

From: Gerard H. Pille <>
Date: Tue, 30 Aug 2011 20:56:39 +0200
Message-ID: <4e5d324b$0$5053$>

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. Received on Tue Aug 30 2011 - 13:56:39 CDT

Original text of this message