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