trouble with inner join mysql

Question

Trying to do a simple inner join, but can't seem to figure out what is going on. Code is:

SELECT *,
FROM flgop as fl
INNER JOIN newuniverse as new
ON fl.Voters_FirstName =new.FirstName
AND fl.Voters_LastName = new.Last 
AND fl.Residence_Addresses_Zip = new.Zip;

Error message I am getting is:

[Err] 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 'FROM flgop as fl
INNER JOIN newuniverse as new
ON fl.Voters_FirstName =new.Fir' at line 2

possible duplicate of [How can I fix MySQL error #1064?](http://stackoverflow.com/questions/23515347/how-can-i-fix-mysql-error-1064) — eggyal, May 10 '14 at 18:07

score 1 · Answer 1 · answered May 08 '14 at 19:53

1

SELECT *, <-- This comma is not necessary
FROM flgop as fl
INNER JOIN newuniverse as new
ON fl.Voters_FirstName =new.FirstName
AND fl.Voters_LastName = new.Last 
AND fl.Residence_Addresses_Zip = new.Zip;

answered May 08 '14 at 19:53

Tom Studee

10,316
4
38
42

trouble with inner join mysql

1 Answers1