Sales Data for all customers and products

MySQL Please!

The query should return all customers ,even customers without invoices and also products,even those products that were not sold.Print NA for null customers or product or null quantity . Order by customerid, productid, and invoiceid

Tables:

Customer

idcustomer_namecity_idcustomer_addresscontact_personemailphone

Product

idskuproduct_nameproduct_descriptioncurrent_pricequantity_in_stock

Invoice

idinvoice_numbercustomer_iduser_account_idtotal_pricetime_issuedtime_duetime_paidtime_canceledtime_refunded

Invoice_Item

idinvoice_idproduct_idquantitypriceline_total_price

Answer rating: 100% (QA)

To achieve the goal of retrieving all customers including those without invoices and all products including those not sold while printing NA for null ... View the full answer