error while using outer join / full outer join in sql

Asked Aug 19 '22 at 09:35

Active Aug 19 '22 at 10:30

Viewed 27 times

my query - select * from members outer join movies on movies.id = members.movie_id;

error :-

15:01:51 select * from members outer join movies on movies.id = members.movie_id Error Code: 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 movies on movies.id = members.movie_id' at line 1 0.000 sec

edited Aug 19 '22 at 10:30

asked Aug 19 '22 at 09:35

shahabaz khan

So you did what the error message told you to do and checked the manual for the syntax - what happened then? – Damien_The_Unbeliever Aug 19 '22 at 09:37
remove `outer` keyword – Jens Aug 19 '22 at 09:40
@ jens i have to use outer keyword for the query... – shahabaz khan Aug 19 '22 at 10:31
@Damien_The_Unbeliever yes i have checked it but it just not working for outer syntax. – shahabaz khan Aug 19 '22 at 10:35
1

`FROM a OUTER JOIN b` is not valid SQL. You must specify which kind of outer join you want: `FROM a LEFT [OUTER] JOIN b`, `FROM a RIGHT [OUTER] JOIN b` (not recommended), `FROM a FULL [OUTER] JOIN b` (not available in MySQL yet) – Thorsten Kettner Aug 19 '22 at 10:36

error while using outer join / full outer join in sql

0 Answers0