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.