[thelist] Basic SQL question

[Damien COLA]

What about :

> SELECT *
> FROM     Members M,
>              MembersColors MC
> WHERE  M.MemberID = MC.MemberID
> AND       MC.MemberColors LIKE '%red%'
> AND		MC.MemberColors LIKE '%blue%);

I don't know if this is efficient in term of speed, but it should work.