David Smith

David Smith

  • NA
  • 2k
  • 0

SQL Where clause Filter Help

Jul 25 2012 2:11 PM
I have dataset, the user wants the option to filter by  three option.  ColorType, ColorStatus, ColorLocation. Color Type has it dropdownbox  values,
ColorStatus has it own dropdownbox value, and also ColorLocation has dropdownbox values relating to the dataset. Can you help me figure out the correct
where clause for the three filters below. all the value are strings, so you can make up any value now

ColorType: ColorStatus: ColorLocation:
select type select status select location


Select ColorID, ColorType, ColorNotes, ColorStatus
From Color Table
Where ????


Answers (1)