SQL statement won't let add a WHERE. Get an error: Incorrect Syntax Near the Keyword WHERE

SELECT MONTH(start) AS 'Month', location, ID, Event,[Start], [End]
FROM dbo.vw_Events Group By Month(start), location, ID, Event, [Start],[End]
ORDER BY [Start] ASC

When ever I try to add a WHERE, I get an error.

Thanks in advance Experts.
colonelblueAsked:
Who is Participating?
 
Kyle AbrahamsSenior .Net DeveloperCommented:
The after the from

SELECT MONTH(start) AS 'Month', location, ID, Event,[Start], [End]
FROM dbo.vw_Events
where ID in (1,2,3)
Group By Month(start), location, ID, Event, [Start],[End]
ORDER BY [Start] ASC
0
 
tobywestonCommented:
Where are you putting the "Where" part of the statement?
0
 
Éric MoreauSenior .Net ConsultantCommented:
what is the code of vw_Events?
0
 
awking00Commented:
What does the statment that gives you the error look like?
0
 
colonelblueAuthor Commented:
Thank you Experts.<br />I was putting the WHERE after the group and not before as tobyweston and ged325<br />pointed put.<br /><br />You guys rock!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.