Syntax Error on SQL INNER JOIN Query Expression

Question

I have an error anymore, it says : "Syntax error (missing operator) in query Expression.

here's my code :

"SELECT AttHadir.IDUser, Hadir.NamaUser, AttHadir.JamMasuk, AttHadir.Threshold," & _
"AttHadir.ModVerifikasi, AttHadir.ModVerifikasi FROM AttHadir INNER JOIN Hadir ON AttHadir.IDUser = Hadir.IDUser" & _
"WHERE AttHadir.IDUser='" & TBox(0).Text & "' AND MONTH(AttHadir.JamMasuk) AS Bulan ='" & Combo(0).Text & "'" & _
"AND YEAR(AttHadir.JamMasuk) AS Tahun='" & Combo(1).Text & "'"

Is everyone know the right one of my code ? Thanks

manimatters · Accepted Answer · 2013-09-10 03:25:10Z

0

Your string would be created as:

SELECT AttHadir.IDUser, Hadir.NamaUser, AttHadir.JamMasuk, AttHadir.Threshold,AttHadir.ModVerifikasi, AttHadir.ModVerifikasi FROM AttHadir INNER JOIN Hadir ON AttHadir.IDUser = Hadir.IDUserWHERE AttHadir.IDUser='' AND MONTH(AttHadir.JamMasuk) AS Bulan =''AND YEAR(AttHadir.JamMasuk) AS Tahun=' '

I think you are missing spaces before AttHadir.ModVerifikasi, WHERE AttHadir.IDUser and AND YEAR(AttHadir.JamMasuk)

answered Sep 10, 2013 at 3:25

manimatters

4443 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax Error on SQL INNER JOIN Query Expression

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related