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