Can someone help me figure out this error

So i use this query

SELECT continent,Population,Name, FROM country a JOIN city b ON name = name WHERE Population > 13000 AND Population < 500000 AND continent != “North America”;

And i keep getting this error in return and I have no clue why. 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 ‘FROM country a JOIN city b ON name = name WHERE Population > 13000 AND Populatio’ at line 1

Can someone help me figure out what I’m doing wrong ???

submitted by /u/That2mittenguy
[link] [comments]


Go to Source of this post
Author Of this post: /u/That2mittenguy
Title Of post: Can someone help me figure out this error
Author Link: {authorlink}