full outer join error #1064

[wright67uk]

I'm trying to do a FULL OUTER JOIN, and i'm coming across an error when I test the SQL in phpmyadmin.

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OUTER JOIN likes

ON public_tips.id=likes.id ORDER BY public_tips.horse

LIMIT 0,' at line 3 

 

 

My full query is;

 

SELECT *

FROM public_tips

FULL OUTER JOIN likes

ON public_tips.id=likes.id

 

 

 

My table structures are similar to:

 

likes

 

Field       Type

id            int(255)

user_id   int(255)

 

public_tips

 

Field       Type

id            int(255) 

time       varchar(10)

course    varchar(255)  

horse      varchar(255)

 

 

Any ideas of where i'm going wrong?

[Barand]

MySql does not support FULL OUTER JOIN, however see http://www.it-iss.com/mysql/mysql-full-outer-join/