[SQL] help with troublesome query

[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 left join of customers 
 with applications but I do not want multiple rows of customers UNLESS 
they have an application.

thanks



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org