|
|
 |
July 04, 2008
i have attatched the query. the problem i have is it appears to be repeating every MEASURe for every item. it should only be showing the measures the items have records for. but as you can see here each item is repeated about 12. (SELECT ITEMS.CUSTNUM1, ITEMS.ITEMNO, ITEMS.DESCRIPT, ITEMS.IMAGEORIG, ITEMS.CATEGORY,ITEMS.CUSTNUM6,ITEMS.CUSTNUM7,ITEMS.SALE_MEAS,ITEMS.CUSTCHAR16 AS LEATHERWEIGHT,MEASURE_FACTOR.CONV_FACTOR As Meas_Factor FROM ITEMS,MEASURE_FACTOR WHERE ITEMS...
Visit Job Site |
Back to Jobs
|