Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- c.FirstName ,
- c.LastName,
- c.Country,
- i.BillingCountry,
- i.CustomerId,
- i.InvoiceDate,
- i.InvoiceId,
- i.Total,
- ii.TrackId,
- ii.UnitPrice,
- ii.Quantity
- FROM invoices i
- INNER JOIN customers AS c
- ON i.CustomerId = c.CustomerId
- INNER JOIN invoice_items AS ii
- ON i.InvoiceId = ii.InvoiceId
- WHERE c.country = "Brazil";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement