Fix My SQL Query
 |
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... |
Other New Jobs from ScriptLance - Freelance Jobs
October 08, 2008
- Account Telephone Verification
- CAPTCHA Workers Needed for 24h
- UPS and USPS shipping rate cal
- Change position
- website & design
- Video Conferencing Software
- recover JOOMLA password
- AU SEO project
- Simple CSS Fix - Make a Box
- Joomla Expert in security
- Improve My Ruby Tutorial
- Flash Product Color Designer
- Myspace social site clone
- Finish PHP Form Processing
- Basic - MENUs
- marketing team
- Tube Script - Mass Embeder EZZ
- Joomla Multi Store Front
- create simple database schema
- soical networking Project