If PRODUCT and VENDOR were combined into one table. Much data redundancy-->potential for data anomalies (multiple inconsistent values) when insert, delete, update. Products and Vendors are two different things, "entities" so should be separate tables. All the data from the two tables is in this full join: SELECT p_code,p_descript,p_indate,p_onhand,p_min,p_price,p_discount,Vendor.v_code,v_name,v_contact,v_areacode,v_phone,v_state,v_order FROM product FULL JOIN vendor ON vendor.v_code=product.v_code ORDER BY v_name; P_CODE P_DESCRIPT P_INDATE P_ONHAND P_MIN P_PRICE P_DISCOUNT V_CODE V_NAME V_CONTACT V_A V_PHONE V_ V ---------- ------------ --------- ---------- ---------- ---------- ---------- ---------- ------------ --------------- --- -------- -- - 25443 B&K, Inc. Smith 904 227-0093 FL N 24004 Brackman Bro Browning 615 228-1410 TN N 23109-HB Claw hammer 20-JAN-02 23 10 9.95 .1 21225 Bryson, Inc. Smithson 615 223-3234 TN Y SM-18277 1.25-in. met 29-DEC-01 172 75 6.99 0 21225 Bryson, Inc. Smithson 615 223-3234 TN Y SW-23116 2.5-in. wd. 24-DEC-01 237 100 8.45 0 21231 D&E Supply Singh 615 228-3245 TN Y 25501 Damal Suppli Smythe 615 890-3529 TN N 22567 Dome Supply Smith 901 678-1419 GA N 14-Q1/L3 9.00-in. pwr 13-JAN-02 18 12 17.49 0 21344 Gomez Bros. Ortega 615 889-2546 KY N 13-Q2/P2 7.25-in. pwr 13-JAN-02 32 15 14.99 .05 21344 Gomez Bros. Ortega 615 889-2546 KY N 54778-2T Rat-tail fil 15-JAN-02 43 20 4.99 0 21344 Gomez Bros. Ortega 615 889-2546 KY N 89-WRE-Q Hicut chain 07-DEC-01 11 5 256.99 .05 24288 ORDVA, Inc. Hakford 615 898-1234 TN Y 2232/QWE B&D jigsaw, 24-JAN-02 6 5 99.87 .05 24288 ORDVA, Inc. Hakford 615 898-1234 TN Y 2232/QTY B&D jigsaw, 30-DEC-01 8 5 109.92 .05 24288 ORDVA, Inc. Hakford 615 898-1234 TN Y 1558-QW1 Hrd. cloth, 15-JAN-02 23 5 43.99 0 23119 Randsets Ltd Anderson 901 678-3998 GA Y 1546-QQ2 Hrd. cloth, 15-DEC-01 15 8 39.95 0 23119 Randsets Ltd Anderson 901 678-3998 GA Y 2238/QPD B&D cordless 20-NOV-01 12 5 38.95 .05 25595 Rubicon Syst Orton 904 456-0092 FL Y 11QER/31 Power painte 03-DEC-01 8 5 109.99 0 25595 Rubicon Syst Orton 904 456-0092 FL Y WR3/TT3 Steel mattin 17-JAN-02 18 5 119.95 .1 25595 Rubicon Syst Orton 904 456-0092 FL Y 21226 SuperLoo, In Flushing 904 215-8995 FL N PVC23DRT PVC pipe, 3. 20-JAN-02 188 75 5.87 0 23114-AA Sledge hamme 02-FEB-02 8 5 14.4 .05 21 rows selected.