Help with inner join

[petschephp]

I'm trying to select all users who do not belong to a specific team_id, but it's not working correctly.

 

I have two database tables

users: id, username, password

users_teams: id, user_id, team_id

 

Code:

SELECT * FROM users LEFT OUTER JOIN users_teams ON users_teams.user_id=users.id WHERE users_teams.team_id != '.$team_id

[requinix]

It may sound weird, but in the JOIN condition put that the team ID must be that $team_id().

SELECT * FROM users LEFT OUTER JOIN users_teams ON users_teams.user_id = users.id AND users_teams.team_id = $team_id() WHERE users_teams.team_id != $team_id()

If that does sound weird then consider changing the WHERE into the functionally equivalent

WHERE users_teams.team_id IS NULL

Make sense now?