A Not Join

Поиск
Список
Период
Сортировка
Искать
От
L van der Walt
Тема
A Not Join
Дата
Msg-id
43677B35.6010005@lani.co.za
Список
Дерево обсуждения
A Not Join L van der Walt <mailing@lani.co.za>
Re: A Not Join "Jim C. Nasby" <jnasby@pervasive.com>
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

В списке pgsql-general по дате отправления
От: Terry Fielder
Дата:
Сообщение: Re: Disappearing Records
От: Tom Lane
Дата:
Сообщение: Re: Disappearing Records
FAQ