USA: +1 (725) 712-1730 
Sign in
A list of the custome. x , A sorted list of the n × 10 CS 346-Database x Co bb cswebdav/pid-1299644-dt-content-rid-10262251_1/courses/CS 346-01 201740/Home Eagle Online- Pearland Homes For D Fridell Scholarship, P D E 110ER/31Power painter, 15 psi., 3-nozzle WR3/TT3 I Steel matting, 4.x8x1/6″, :5″ mesh 8 109.99Rubicon Sis 18 119.95 Rubicon Sis A sorted list of the names of all the vendors in the database showing the products they supply or NULL if they don’t supply any products as shown below. Vendor name Product code Description B&K, Inc. NULL Brackman Bros. NULL Bryson, Inc. 23109-HB Claw hammer Bryson, Inc. SM-18277 1.25-in. metal screw, 25 D&E Supply sw-23116 2.5-in. wd, screw, 50 Damal Supplies NULL Dome Supply NULL Gomez Bros. 13-02/P2 7.25-in.pwr. saw blade Gomez Bros. 14-01/13 9.00-in. pwr. saw blade Gomez Bros. 54778-2T Rat-tail file, 1/8-in. fine ORDVA, Inc. 2232/QTY B&D jigsaw, 12-in. blade NULL NULL Quantity on Hand Unit Price NULL NULL NULL NULL 23 172 237 9.95 6.99 8.45 NULL NULL NULL NULL NULL NULL 32 18 43 14.99 17.49 4.99 ORDVA, Inc. 89-WRE-Q Hicut chain saw, 16 in Randsets Ltd. 1546-002 Hrd. cloth, 1/4-in., 2×50 Randsets Ltd. 1558-QW1 Hrd. cloth, 1/2-in., 3×50 Rubicon Sis. 110ER/31 Power painter, 15 psi., 3-nozzle Rubicon Sis. 2238/QPD BI&D cordless drill, 1/2-in 8 109.92 99.87 11 256.99 39.95 23 43.99 8 109.99 12 38.95 18 119.95 15 ubicon Sis. WR3/TT3 Steel matting, 4’x8x1/6″, 5″ mesh SuperLoo, Inc. NULL NULL NULL NULL ho never nurchased any nroducts as shown below
Expert Answer
SELECT V.Vendor_Name, NVL(P.Poduct_Code,”NULL”),NVL(P.Description,”NULL”),P.Qtyoh AS Quantity _on_Hand,P.Unit_Price FROM VENDOR V FULL OUTER JOIN PRODUCT P WHERE V.V_Code=P.V_Code ORDER BY V.Vendor_Name;
This query retrieves the required result.
Here Full Outer Join retrieves all the rows from the 2 tables based on the where condition in the sorted order of name.
NVL(Product _Code,”Null”) :- This means it checks the first the product _code if it is there then it displays the product code otherwise if there is no product _code available then it displays “Null” Text there in that row.
