Sorting

[raouleduke]

I am trying to sort my query to only contain certain field values, Here is the code any help would be appreciated.

$query = "SELECT Hold, FollowUpNeeded, CustomerNotReached FROM KEYCAD WHERE Hold='N', FollowUpNeeded='0', CustomerNotReached='0'  GROUP BY CUST-NO  ORDER BY ContactDate DESC";

[tomhath]

The WHERE clause uses AND, not commas:

SELECT Hold, FollowUpNeeded, CustomerNotReached
FROM KEYCAD
WHERE Hold='N'
AND FollowUpNeeded='0'
AND CustomerNotReached='0'

GROUP BY CUST-NO

ORDER BY ContactDate DESC

[raouleduke]

Thanks so much!