شباب رمضان كريم عليكم
اخوكم جديد
ارجو المساعدة في فهم الاتي و ما هي المخرجات
--- What this query is trying to do:
Select
CUST.CUSTOMER_ID
, ORD.ORDER_ID
, LINES.ORDERLINES_ID
, PRD.PRODUCT
, PRD.PRODUCT_DESCRIPTION
, LINES.AMOUNT
, (LINES.AMOUNT * .17) AMOUNT_VAT
FROM
CUSTOMER CUST
INNER JOIN ORDERS ORD ON CUST.CUSTOMER_ID = ORD.CUSTOMER_ID
INNER JOIN ORDERLINES LINES ON ORD.ORDER_ID = LINES.ORDER_ID
LEFT OUTER JOIN PRODUCT PRD ON LINES.PRODUCT_ID = PRD.ID
ORDER BY 1,2,3