Advertisement
Guest User

Untitled

a guest
Feb 24th, 2020
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.34 KB | None | 0 0
  1. SELECT
  2.     c.FirstName ,
  3.     c.LastName,
  4.     c.Country,
  5.     i.BillingCountry,
  6.     i.CustomerId,
  7.     i.InvoiceDate,
  8.     i.InvoiceId,
  9.     i.Total,
  10.     ii.TrackId,
  11.     ii.UnitPrice,
  12.     ii.Quantity
  13. FROM invoices i
  14. INNER JOIN customers AS c
  15. ON i.CustomerId = c.CustomerId
  16. INNER JOIN invoice_items AS ii
  17. ON i.InvoiceId = ii.InvoiceId
  18. WHERE c.country = "Brazil";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement