Shawn Cummings schrieb:
If I have (2) tables. Like
GROUP , CODE
GRP1, AA
GRP1, AB
GRP1, AC
GRP2, BA
GRP2, BB
GRP2, BC
And;
USER , UCODE
ME, AA
ME, AC
YOU, AA
What's the best way to query to find out if "ME" has all codes in either of
the groups?
In other words, I want to know if I have all (3) CODEs required for GRP1,
and all (3) CODEs required for GRP2?
WHERE EXISTS and WHERE NOT EXISTS might be your problem solvers here,
depending on your mysql version.
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
