In your examples, ID 2 should NOT get returned. What I'm after is analogous to a Perl hash where you could say:
if (!exists $colors{2}->{blue}) { ... } Make sence? --- Rodney Broom Programmer: Desert.Net Spam filter: sql database --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php