Incorrect syntax in SQL Statement

[jasonhuibers]

What is wrong with this statement? I keep getting error:
Incorrect syntax near 'EventHistory'


sql_insert = "SELECT Event.EventName,Event.EventType,COUNT(*) FROM EVENT WITH (NOLOCK) " & _
"INNER JOIN EventHistory WITH (NOLOCK) ON Event.RecordNum = EventHistory.RecordNum" & _
"WHERE EventHistory.RecordNum = 2 AND EventHistory.Vendor is not null" & _
"GROUP BY Event.EventName,Event.EventType"

 

[gmmastros]

Looks like you are missing a space after EVENTHISTORY.RECORDNUM and before the WHERE.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom