Akhter HUssain

Akhter HUssain

  • 1.2k
  • 1k
  • 59.8k

How to view all sales order details by using SQL statment.?

Apr 12 2019 6:25 AM
i have tables customer(CustomerID,CustomerName),,, Item_master(Item_code,Item_Name)
sales_Order(orderno,customerId) and orderdetails(Orderno,item_code,qty)
 
i want sql query or view in which all orderdetails order to display like
 
orderno|CustomerName|Item_Name|qty
 
please guide...

Answers (3)