| From: | L van der Walt <mailing(at)lani(dot)co(dot)za> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | A Not Join |
| Date: | 2005-11-01 14:27:01 |
| Message-ID: | 43677B35.6010005@lani.co.za |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
I have three table:
Users - Contains username, ID etc...
Permissions - A permission name and ID
Link up table - The user.id and permission.id
If a user.id and a permission.id row exists in the linkuptable the user
have that permission granted.
With the statement below I can see the permissions a user have.
SELECT users.username, permissions.name
FROM users INNER JOIN linkuptable
ON (users.id = linkuptable.userid)
INNER JOIN permissions
ON (permissions.id = linkuptable.permissionid)
WHERE users.username = 'DummyUser'
How do I see the permissions that user DON'T have with a fast SQL statement.
Thus, a NOT the statement for the above SQL statement
Regards
Lani
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Rawnsley | 2005-11-01 14:29:50 | Re: Oracle 10g Express - any danger for Postgres? |
| Previous Message | Terry Fielder | 2005-11-01 14:17:24 | Re: Disappearing Records |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daryl Richter | 2005-11-01 14:45:09 | Re: Fwd: Re: Referencing |
| Previous Message | lucas | 2005-10-31 19:58:27 | Re: Fwd: Re: Referencing |