was ist denn der genaue unterschied zwischen folgenden SELCTS unter mySQL.

[sql]SELECT * from candidate, photos WHERE candidate.id = photos.candidate_id AND candidate.id = 7;
[/sql]

[sql]SELECT * from candidate INNER JOIN photos ON candidate.id = photos.candidate_id WHERE candidate.id = 7;
[/sql]

[sql]SELECT * from candidate LEFT JOIN photos ON candidate.id = photos.candidate_id WHERE candidate.id = 7;
[/sql]

[sql]SELECT * from candidate RIGHT JOIN photos ON candidate.id = photos.candidate_id WHERE candidate.id = 7;
[/sql]

irgendwie raff ich es noch nicht.
momentan bekomm ich nämlich immer das selbe ergebnis!