VENDOR
+--------+-----------------+-----------+------------+----------+---------+---------+
| v_code | v_name          | v_contact | v_areacode | v_phone  | v_state | v_order |
+--------+-----------------+-----------+------------+----------+---------+---------+
|  21225 | Bryson, Inc.    | Smithson  | 615        | 223-3234 | TN      | Y       | 
|  21226 | SuperLoo, Inc.  | Flushing  | 904        | 215-8995 | FL      | N       | 
|  21231 | D&E Supply      | Singh     | 615        | 228-3245 | TN      | Y       | 
|  21344 | Gomez Bros.     | Ortega    | 615        | 889-2546 | KY      | N       | 
|  22567 | Dome Supply     | Smith     | 901        | 678-1419 | GA      | N       | 
|  23119 | Randsets Ltd.   | Anderson  | 901        | 678-3998 | GA      | Y       | 
|  24004 | Brackman Bros.  | Browning  | 615        | 228-1410 | TN      | N       | 
|  24288 | ORDVA, Inc.     | Hakford   | 615        | 898-1234 | TN      | Y       | 
|  25443 | B&K, Inc.       | Smith     | 904        | 227-0093 | FL      | N       | 
|  25501 | Damal Supplies  | Smythe    | 615        | 890-3529 | TN      | N       | 
|  25595 | Rubicon Systems | Orton     | 904        | 456-0092 | FL      | Y       | 
+--------+-----------------+-----------+------------+----------+---------+---------+
11 rows in set (0.01 sec)

     PRODUCT
+----------+-----------------------------------+------------+----------+-------+---------+------------+--------+
| p_code   | p_descript                        | p_indate   | p_onhand | p_min | p_price | p_discount | v_code |
+----------+-----------------------------------+------------+----------+-------+---------+------------+--------+
| 11QER/31 | Power painter, 15 psi., 3-nozzle  | 2001-12-03 |        8 |     5 |  109.99 |       0.00 |  25595 | 
| 13-Q2/P2 | 7.25-in. pwr. saw blade           | 2002-01-13 |       32 |    15 |   14.99 |       0.05 |  21344 | 
| 14-Q1/L3 | 9.00-in. pwr. saw blade           | 2002-01-13 |       18 |    12 |   17.49 |       0.00 |  21344 | 
| 1546-QQ2 | Hrd. cloth, 1/4-in., 2x50         | 2001-12-15 |       15 |     8 |   39.95 |       0.00 |  23119 | 
| 1558-QW1 | Hrd. cloth, 1/2-in., 3x50         | 2002-01-15 |       23 |     5 |   43.99 |       0.00 |  23119 | 
| 2232/QTY | B&D jigsaw, 12-in. blade          | 2001-12-30 |        8 |     5 |  109.92 |       0.05 |  24288 | 
| 2232/QWE | B&D jigsaw, 8-in. blade           | 2002-01-24 |        6 |     5 |   99.87 |       0.05 |  24288 | 
| 2238/QPD | B&D cordless drill, 1/2-in.       | 2001-11-20 |       12 |     5 |   38.95 |       0.05 |  25595 | 
| 23109-HB | Claw hammer                       | 2002-01-20 |       23 |    10 |    9.95 |       0.10 |  21225 | 
| 23114-AA | Sledge hammer, 12 lb.             | 2002-02-02 |        8 |     5 |   14.40 |       0.05 |   NULL | 
| 54778-2T | Rat-tail file, 1/8-in. fine       | 2002-01-15 |       43 |    20 |    4.99 |       0.00 |  21344 | 
| 89-WRE-Q | Hicut chain saw, 16 in.           | 2001-12-07 |       11 |     5 |  256.99 |       0.05 |  24288 | 
| PVC23DRT | PVC pipe, 3.5-in., 8-ft           | 2002-01-20 |      188 |    75 |    5.87 |       0.00 |   NULL | 
| SM-18277 | 1.25-in. metal screw, 25          | 2001-12-29 |      172 |    75 |    6.99 |       0.00 |  21225 | 
| SW-23116 | 2.5-in. wd. screw, 50             | 2001-12-24 |      237 |   100 |    8.45 |       0.00 |  21231 | 
| WR3/TT3  | Steel matting, 4x8x1/6", .5" mesh | 2002-01-17 |       18 |     5 |  119.95 |       0.10 |  25595 | 
+----------+-----------------------------------+------------+----------+-------+---------+------------+--------+
16 rows in set (0.06 sec)