"Alan Dickinson" <[EMAIL PROTECTED]> wrote:
>
> 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?
>
If I've got you right you need:
SELECT .. GROUP BY part_description
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
