improper syntax near UNION

I am getting improper syntax near 'UNION'
- I dont see it
SELECT 'TIE IN' as [Type], Inclination,VerticalDepth,CreatedOn, 'ACCEPTED' as [Status] 
FROM SS_TieIn 
WHERE JobID = 10299;
UNION ALL
Select 'SURVEY' as [Type],Inclination,SurveyDepth as 'Bit Depth',SurveyDateTime,'ACCEPTED' as [Status] 
FROM SS_Surveys 
WHERE JobID = 10299 and SurveyStatus = 1;

Open in new window

LVL 6
r3nderAsked:
Who is Participating?
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Remove the semicolon before UNION.
0
 
r3nderAuthor Commented:
uuuhhhggg, thanks
0
 
r3nderAuthor Commented:
Thanks Qlemo
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.