FULL OUTER JOIN

[expired user #7442]'s profile image [expired user #7442] posted 10 years ago in Running SQL scripts Permalink
Hie can someone pl;ease give me some info as to how i can execute
a full outer join in Heidisql. i have tried the following

SELECT * FROM table_A
FULL OUTER JOIN table_B
ON table_A.A=table_B.A;

but i get the following error

SQL Error(1064): You have an error in your sql syntax.....near 'FULL OUTER JOIN'....
ansgar's profile image ansgar posted 10 years ago Permalink
Please refer to the MySQL documentation. I'm not sure but I think you just need "OUTER JOIN", not "FULL OUTER JOIN".
[expired user #7442]'s profile image [expired user #7442] posted 10 years ago Permalink
Thanks But outer join wont work as well let me go through the documentation
[expired user #9001]'s profile image [expired user #9001] posted 9 years ago Permalink
please help me with FULL OUTER JOIN for MySql

Please login to leave a reply, or register at first.