Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

FULL OUTER JOIN

2 posts

[expired user #7442] posted 10 years 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'....

9920 posts

ansgar posted 10 years ago

Please refer to the MySQL documentation. I'm not sure but I think you just need "OUTER JOIN", not "FULL OUTER JOIN".

2 posts

[expired user #7442] posted 10 years ago

Thanks But outer join wont work as well let me go through the documentation

1 posts

[expired user #9001] posted 8 years ago

please help me with FULL OUTER JOIN for MySql

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