opdracht-1/t5.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

select
  Klant.ID as Klantnr,
  Klant.Naam,
  `Order`.ID as Ordernr,
  `Order`.Besteldatum as dtBesteldatum,
  `Order`.Status,
  Product.Naam as Product,
  Product.Eenheid,
  Product.Beschrijving,
  OrderProduct.Aantal
from Klant
join `Order` on `Order`.KlantID = Klant.ID
join OrderProduct on OrderProduct.OrderID = `Order`.ID
join Product on Product.ID = OrderProduct.ProductID;