I want to know the invoice dates corresponding to customers
select t1.firstname, t1.lastname, t2.invoicedate from customer as t1 join invoice as t2 on t1.customerid = t2.customerid
Could you please help me with the billing addresses of the named customers?
select t1.firstname, t1.lastname, t2.billingaddress from customer as t1 join invoice as t2 on t1.customerid = t2.customerid
Ok, I will also want to know the billing countries of the named customers
select t1.firstname, t1.lastname, t2.billingcountry from customer as t1 join invoice as t2 on t1.customerid = t2.customerid
OK, I will like to know the billing city of the names customers please.
select t1.firstname, t1.lastname, t2.billingcity from customer as t1 join invoice as t2 on t1.customerid = t2.customerid