Everytime i run this query on mysql-workbench i get error

Question

SELECT 
 first_table.Name, 
 second_table.Working_hours 
FROM first_table 
FULL OUTER JOIN second_table 
  ON first_table.Member_id=second_table.Member_id;

Answer 1

MySQL doesn't support FULL OUTER JOIN. And the error you get if you try can be misleading.

The error is the result of a syntax bug in MySQL. The standard SQL keyword FULL is not treated as a reserved word. Using the keyword FULL therefore acts like a table alias.

It's as if you had written the query like this:

SELECT 
 first_table.Name, 
 second_table.Working_hours 
FROM first_table AS `FULL`
OUTER JOIN second_table 
  ON first_table.Member_id=second_table.Member_id;

The error is that OUTER JOIN needs either the LEFT or RIGHT qualifier, but neither is present in this case.