[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