Sebastian Tennant <[EMAIL PROTECTED]>
wrote:
I have three tables; users, propositions, and subscriptions:
users
-----
user_id user_name user_password user_email
propostions
-----------
prop_id proposition user_id
subscriptions
-------------
sub_id prop_id user_id
Given a particular user, I want to return the set of 'interesting'
propositions, i.e., those which were not proposed by the user and to
which the user is not already subscribed...
select * from propositions p
where p.user_id != :userId and not exists (
select * from subscriptions s
where p.prop_id = s.prop_id and s.user_id = :userId
);
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
