1 files changed, 14 insertions, 0 deletions
diff --git a/opdracht-1/t5.sql b/opdracht-1/t5.sql
new file mode 100644
index 0000000..7d97b92
--- /dev/null
+++ b/opdracht-1/t5.sql
@@ -0,0 +1,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;