I've got a query that looks like this..
"SELECT Foot_Id, Dir_Uni, Part_Suffix, Part_Number, Appln_No, Description,
Product_Ref, Vehicle_Ref, Part_Prompt, Part_Description, Foot_Id,
Qualifier, Years
FROM application_parts
WHERE (('$id' = Appln_No) and (Years = '$dropdown') and (Dir_Uni <> 'U')
and (Part_Description <> 'Pipe Kit')
and (Part_Description <> 'Universal Converter') and (Part_Description <>
'Pre Cat'))
ORDER BY Part_Prompt";
(sorry if the spacing is weird)
I need to drop the rows returned that have the same part_description field,
like the DISTINCT clause does for rows, i need the same thing for a field
value, how can I do this?
Thanks for the help,
Alan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
