How to join two tables left or right or inner?

<?php
// Joining Tables with Left ,Right,Inner

mysql_connect("localhost", "root", "pass") or die(mysql_error());
mysql_select_db("dbname") or die(mysql_error());

//Left Join tables
$query =  mysql_query("SELECT namne, age, designation FROM emp LEFT JOIN empdesig ON  emp.eid=empdesig.id");

// Right Join tables
$query =  mysql_query("SELECT name, age, designation FROM emp RIGHT JOIN empdesig ON emp.pid=empdesig.id");


// Inner Join

$query =  mysql_query("SELECT * FROM emp a INNER JOIN empdesif b  ON a.empid = b.empdesig");

?>