use of inner or outer join

hi guys,

i am wondering under what circumstances we will have to use inner or outer join ???

besides of that, can somebody also explain what is this query meant ?
$result = mysql_query("select* from cart inner join items on cart.itemId = items.itemId where cart.cookieId = '$carId' order by items.itemName asc");

please advise.

thanks.