Thread: help with troublesome query

help with troublesome query

From
teknokrat
Date:
I have three tables customers which 1-many with requests which is 1-1 
with applications. all customers have at least one request but not all 
requests have an application.

I want a query to return all the customers and their application data if 
they have any ( or else null). So this is like a left join of customers  with applications but I do not want multiple
rowsof customers UNLESS 
 
they have an application.

thanks




Re: help with troublesome query

From
Bruno Wolff III
Date:
On Tue, Jul 15, 2003 at 14:26:16 +0100, teknokrat <teknokrat@yahoo.com> wrote:
> I have three tables customers which 1-many with requests which is 1-1 
> with applications. all customers have at least one request but not all 
> requests have an application.
> 
> I want a query to return all the customers and their application data if 
> they have any ( or else null). So this is like a left join of customers 
>  with applications but I do not want multiple rows of customers UNLESS 
> they have an application.

I think you want to first do an inner join of requests and applications
and then left join the customers and the previous join.