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

FULL OUTER JOIN

btumbude posted 1 year 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 1 year 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 1 year 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.