How do i retrieve the records that are NOT linked?
| From: | Simon Kimber | Date: | Sat, 20 Oct 2001 19:51:14 +0000 |
| Subject: | How do i retrieve the records that are NOT linked? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-71701@lists.php.net to get a copy of this message | ||
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