SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Item(ITEM_NO CHAR(12),ITEM_DESC CHAR(30)); CREATE TABLE ORDERED(CUST_NO CHAR(15),ITEM_NO CHAR(12),QTY_ORDERED INT); INSERT INTO Item(Item_NO,Item_Desc) VALUES (1, 'Large Bags'),(2, 'Medium Bags'),(3, 'Large Boxes'),(4, 'Medium Boxes'); INSERT INTO ORDERED(CUST_NO,Item_NO,Qty_Ordered) VALUES (1 , 1 , 10),(1 , 2 , 15),(1 , 4 , 20),(2, 3 , 30),(2, 4 , 40),(3, 1 , 20),(3, 2 , 50), (3,3 , 10); select * from item; select * from ORDERED; select c.cust_no, c.item_no,coalesce(c.qty_ordered,0) from ORDERED c cross join item i on i.item_no = c.item_no;