Re: [GENERAL] using subselects

2007-06-07 Thread Alban Hertroys
[EMAIL PROTECTED] wrote: > I'm creating a select list on a web form for adding a new user to a > project. I want to select users from the user table, who aren't > already listed in the join table under that project. > > Here's my select: > SELECT * FROM users > WHERE user_id <> $current_user_id >

[GENERAL] using subselects

2007-06-07 Thread lawpoop
Hello everyone - I'm moving from MySQL to Postgres and I am in a situation where I am trying to use subselects properly. I have a table of projects, users, and user_projects. The table user_projects creates a many-to-many relationship between users and projects. I'm creating a select list on a w