SELECT DISTINCT T1.Address FROM CUSTOMER AS T1 JOIN INVOICE AS T2 ON T1.CustomerId  =  T2.CustomerId WHERE T1.country  =  "Germany"
Find the address of all customers that live in Germany and have invoice.
SELECT DISTINCT T1.Address FROM CUSTOMER AS T1 JOIN INVOICE AS T2 ON T1.CustomerId = T2.CustomerId WHERE T1.country = `` Germany ''
select distinct t1 . address from customer as t1 join invoice as t2 on t1 . customerid = t2 . customerid where t1 . country = value
Find the address of all customers that live in Germany and have invoice .