Re: [SQL] help with troublesome query

2003-07-15 Thread Bruno Wolff III
On Tue, Jul 15, 2003 at 14:26:16 +0100, teknokrat <[EMAIL PROTECTED]> 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 cus

[SQL] help with troublesome query

2003-07-15 Thread teknokrat
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 le