Two tables :
customer -> customerid
address -> customerid,addresstype
a customer can have more types of addresses :
I want to show all customers with their addresses.
They addresses must be of type 'postaddress'
If a customer doesn't have a address of type 'postaddress' then still show the record with the customerfields and empty address fields.
query : select * from customers,address where
customer.customerid = address.customerid (+) and
addresstype = 'postaddress'
This query shows only the customers with "postaddresses" but not the customers without a address or customers with a "privateaddress".
So I am looking for a query that shows the customers with postaddresses and also the customers with empty or other type of addresses but then they addressfields should be empty.
Who can help me ?