[thelist] Basic SQL question

Bob Haroche spambait at onpointsolutions.com
Sat Jan 3 02:18:58 CST 2004


I feel like I'm missing something obvious here. You tell me...

To simplify the issue, I want to select info about members who are
associated with colors. This SQL statement will return members who are
associated with red OR blue:

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

Instead I want to retrieve data only about members who are associated with
both red AND blue.

What's the approach here, using MS Access (and CFML)?

Thanks.

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




More information about the thelist mailing list