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

FULL OUTER JOIN

User, date Message
Written by btumbude
10 months ago
Category: Running SQL scripts
2 posts since Wed, 27 Nov 13
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'....
Written by ansgar
10 months ago
5023 posts since Fri, 07 Apr 06
Please refer to the MySQL documentation. I'm not sure but I think you just need "OUTER JOIN", not "FULL OUTER JOIN".
Written by btumbude
10 months ago
2 posts since Wed, 27 Nov 13
Thanks But outer join wont work as well let me go through the documentation
 

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