Re: Variation of SELECT DISTINCT

2003-11-24 Thread Egor Egorov
"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 appl

Variation of SELECT DISTINCT

2003-11-21 Thread Alan Dickinson
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