distal-attribute
distal-attribute
distal-attribute
distal-attribute

FULL OUTER JOIN

btumbude posted 11 months ago in Running SQL scripts
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 posted 11 months ago
Please refer to the MySQL documentation. I'm not sure but I think you just need "OUTER JOIN", not "FULL OUTER JOIN".
btumbude posted 11 months ago
Thanks But outer join wont work as well let me go through the documentation

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