Mysql join query in mysql and php

Mysql join query in mysql and php


<?php
$sql="select id ,name , address, city  from  table1  , table2  where table1.id=table2.cusid ";
?>
inner join
<?php
$sql="select id ,name , address, city  from table1 INNER JOIN table2 ON table1.id=table2.cusid ";
?>
left join
<?php
$sql="select id ,name , address, city  from table1 LEFT JOIN table2 ON table1.id=table2.cusid ";
?>
right join
<?php
$sql="select id ,name , address, city  from table1 RIGHT JOIN table2 on table1.id=table2.cusid ";
?>
full join
<?php
$sql="select id ,name , address, city  from table1 FULL JOIN table2 on table1.id=table2.cusid ";
?>