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

btumbude's profile image btumbude posted 9 years ago in Running SQL scripts Permalink
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's profile image ansgar posted 9 years ago Permalink
Please refer to the MySQL documentation. I'm not sure but I think you just need "OUTER JOIN", not "FULL OUTER JOIN".
btumbude's profile image btumbude posted 9 years ago Permalink
Thanks But outer join wont work as well let me go through the documentation
sadammohamed1@gmail.com's profile image sadammohamed1@gmail.com posted 7 years ago Permalink
please help me with FULL OUTER JOIN for MySql

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




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.