Question

write a query ,tha will for all products returns each product details name wit its amount due,paid, cancelled and refunded order the results by products name ascending

​

Answer 1

Run the Orders Query (Orders Qry on the Query list): It lists all orders for all customers, without going into line items (order details), by retrieving related data from the Orders and Customers tables. Note the number of rows and columns; several columns are repeated more often than strictly necessary.