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] -----------------------------------------------------------------------------