[thelist] Basic SQL question

[Bob Haroche]

> SELECT *
> FROM     Members M,
>              MembersColors MC
> WHERE  M.MemberID = MC.MemberID
> AND       MC.MemberColors IN (red,blue);

I should elaborate on this over-simplified example. The "colors" will not
actually be fixed values but will be form
variables returned in a list of an unknown length. So one form submission
might return "colors=red,blue,green" while another might return
"colors=yellow,silver".

-------------
Regards,
Bob Haroche
O n P o i n t  S o l u t i o n s
www.OnPointSolutions.com