FULL JOIN

[arunpatal]

Hi,

 

I have 2 tables

 

category (cat_id, cat_name)

AND

subcategory(sub_cat_id, sub_cat_name, category_id)

 

I am tring to run a simple full join statement.

<?php 

require("connect/connection.php"); 

$sql = mysql_query("

SELECT *
FROM $category
FULL JOIN $subcategory
ON $category.cat_id = $subcategory.category_id
") or die(mysql_error()); 


?>

And i get a error

 

Unknown column 'category.cat_id' in 'on clause'

[jazzman1]

As far as I know, MySQL doesn't support a full outer join only left and right joins.

Edited December 5, 2013 by jazzman1

[arunpatal]

As far as I know, MySQL doesn't support a full outer join only left and right joins.

Yes, you are right

[Barand]

I believe you can simulate a FULL join with a union of two LEFT joins