Mysql Full Join (Unknown column in field list)

Question

I always got an error from mysql my syntax is:

SELECT n.id, n.name, s.Surname, s.Gender FROM name FULL JOIN Surname ON n.id = s.id;

(i was doing full join) help me

`FULL JOIN`s are not supported by MySQL. See [this question.](https://stackoverflow.com/questions/4796872/full-outer-join-in-mysql) — krismath, Jul 31 '17 at 11:10

score 0 · Answer 1 · answered Jul 31 '17 at 11:10

0

You have not specified variables(alias names) "n" and "s". please add them after the table names and then try.

answered Jul 31 '17 at 11:10

Akash Deep Sharma

Just this suggestion alone won't fix the problem. – Tim Biegeleisen Jul 31 '17 at 11:11
i already used a specify term but then i got it wrong also – Angelica Demagante Jul 31 '17 at 11:12

1 Answers1