[SOLVED] Join vs left join

[Locked]

I have been looking though sites with these tutorials on them, i understand how to use them but i dont understand the difference between the 2 joins, i know that left join gives extra attention to the left table but what does that mean? it reads it first or what? and is there a certain time when you would use these or just preference?

 

<?php
$select=$q("SELECT UserExp.CrimeExp, User.Nerve,  CrimeList.ExpNeeded, CrimeList.ExpGain, CrimeList.ExpLoss, CrimeType.Nerve as CTNerve FROM UserExp,User,CrimeList,CrimeType
where CrimeList.CrimeID=CrimeType.ID AND CrimeType.ID='$_GET[type]'")or die(mysql_error());
?>

 

I used join for that, would left join be more suitable?

[Barand]

see

 

http://www.w3schools.com/sql/sql_join.asp