I have the following situation:
* id_team is a foreign key in the "player" table.
* There are players that doesn't have a team.
if I make the following select:
SELECT P.first_name,P.last_name,T.team_name FROM
player P, team T WHERE
and the player does not have a valid team, I don't receive any recor in return despite the player exists.
Is there a way to retreive the record despite my foreign key(id_team) is null?
thanks in advance for any help.