Hi All, Are there any MySQL "gurus" who can help me solve this problem?
I have three tables... users, categories and category_user_rights.... "categories" contains: ID, parent_ID, name "users" contains: username, password, name, etc.... "category_user_rights" contains: username, category_ID How do I pull everything out of "categories" that a given user DOES NOT have rights to? ie. every record from "categories" that does not have a record in "category_user_rights" linking it to a username such as "fred" Any help on this would be greatly appreciated! Thanks! Simon Kimber -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]