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

FULL OUTER JOIN

User, date Message
Written by btumbude
5 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
5 months ago
4789 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
5 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.