SQL:
SELECT * FROM `orderregel`
INNER JOIN `klant` ON order.KlantId = klant.KlantId
INNER JOIN `product` ON orderregel.ProductId = product.ProductId
INNER JOIN `order` ON orderregel.OrderId = order.OrderId;
ERROR: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order., orderregel., product., klant. FROM
orderregel
INNER JOINklant
O' at line 1
My database: order(OrderId, KlantId(FK)), orderregel(OrderregelId, OrderId(FK), ProductId(FK), KlantId(FK)), klant(KlantId, Naam, Voornaam), product(ProductId, Naam)
I want to display product.Naam, klant.Naam from each orderregel who has an own order