Untitled

SELECT c.*, o.orderID, o.orderDate, l.orderedQuantity, p.*,
	l.orderedQuantity * p.productStandardPrice AS 'Line Total'
FROM Customer_T c, Order_T o, OrderLine_T l, Product_T p
WHERE c.customerID = o.customerID AND o.orderID = l.orderID AND l.productID = p.productID 
	AND o.orderID= '1006'