This is probably quite easy, but I'm not very good at sql.
I want to be able to display all of the order details on one page.
I want to get OrderDate, CardType, CardNumber, Cardexpmonth, Cardexpyear, Completed from the Order table,
CustFirstName, CustSurname, CustAddress1, CustAddress2, CustPostcode, CustEmail from the Customer table, where the CustID is the same as that in Order,
Model, Price from Products where the Product ID is the same as that in ProductOrder,
And finally the Make, where MakeID is the same as that in Product.
Kinda complicated huh?
Any help would be appreciated.