Problems with FULL OUTER JOIN in MySql

Question

So this is my query

SELECT user_items.userid, users.username
FROM user_items
FULL OUTER JOIN users ON user_items.userid = users.username

And I get the limit 0,25 error. Could you please help me to see what I did wrong?

There isn't a full join of any sort in mysql try searching mysql full join for alternatives. — P.Salmon, Nov 18 '18 at 13:44

score 0 · Accepted Answer · answered Nov 18 '18 at 13:46

0

Oke I was stupid didn't know dat mysql doesn't have a full join

answered Nov 18 '18 at 13:46

1 Answers1