Home | How it works | Projects archive | Contact Us
Air Compressor Bot 		 
The Career Path of Freelance Programming Jobs 

   Fix My Sql Query
Bidding Time:
03/07/2008 22:30 - 17/07/2008 22:30
Budget:
$1-10
Status:
 Closed


Job Type:
SQL
Description:

Professional Hosting from Just Host

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.ACTIVE = 'T' AND ITEMS.WEB_ACTIVE = 'T' AND ITEMS.CATEGORY =
'$c' AND ITEMS.CUSTCHAR3 LIKE '$SITECODE'
AND (ITEMS.MATRIX_ITEM_TYPE = '0' OR ITEMS.MATRIX_ITEM_TYPE = '1' OR
ITEMS.MATRIX_ITEM_TYPE = '3') AND MEASURE_FACTOR.MEAS_CODE = ITEMS.SALE_MEAS)
union
(SELECT ITEM_EQ.CUSTNUM1, ITEM_EQ.ITEMNO, ITEM_EQ.DESCRIPT, ITEMS.DESCRIPT,
ITEM_EQ.CATEGORY,
ITEM_EQ.CUSTNUM6,ITEM_EQ.CUSTNUM7,ITEM_EQ.MEAS_CODE AS
SALE_MEAS,ITEM_EQ.CUSTCHAR4 AS LEATHERWEIGHT, MEASURE_FACTOR.CONV_FACTOR As
Meas_Factor
FROM
ITEM_EQ, ITEMS, MEASURE_FACTOR
WHERE ITEMS.ITEMNO = ITEM_EQ.ITEMNO AND ITEM_EQ.ACTIVE = 'T' AND
ITEM_EQ.WEB_ACTIVE = 'T' AND ITEM_EQ.CATEGORY = '$c'
AND ITEM_EQ.CUSTCHAR3 LIKE '$SITECODE' AND MEASURE_FACTOR.MEAS_CODE =
ITEM_EQ.MEAS_CODE)
ORDER BY CUSTNUM1, DESCRIPT ASC

Start your work-at-home career for $7.00. Get direct access to thousands of freelance and home-based jobs. Click here to find work now.

Related Projects:
Make Forms Work on Flash Template
DMOZ Listing
Web Template Customization
5 articles
Install userplane on dating site

This project is the proprietary information of . Click here to remove this project from OUR database.
Operating System:
 N/A
Database System:
 N/A
<<< back

Recent Projects Archive:

Saturday - Friday - Thursday - Wednesday - Tuesday - Monday - Sunday

View all freelance web projects
 
Home | Projects archive | RSS | Resources | Links | Contact Us © 2004-2008 ProjectsList.biz /0.414