Re: Query question

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



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