http://www.techonthenet.com/sql/joins.php

Please review the following link. This might help you for future reference too.