September 17, 2018 at 11:56 am
I am trying to determine a problem in some software I'm running:
I type the following:
Select
*
From
ILT_ProductAssignment pa
left outer join ILT_BadgeInfo bi on pa.ProductAssignmentID = bi.ProductAssignmentID
Where
OrderNumber = '563'
I get the following error:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ' '.
I have attempted to remove the single quotations, add double quotations remove the space between the = and 563. Still get the same error. Also tried
Select
*
From
ILT_ProductAssignment
Where
OrderNumber = '563'
Same thing? Can anyone identify what I've been doing wrong? Thanks
September 17, 2018 at 1:12 pm
jadwalke - Monday, September 17, 2018 11:56 AMI am trying to determine a problem in some software I'm running:I type the following:
Select
*
From
ILT_ProductAssignment pa
left outer join ILT_BadgeInfo bi on pa.ProductAssignmentID = bi.ProductAssignmentID
Where
OrderNumber = '563'
I get the following error:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ' '.I have attempted to remove the single quotations, add double quotations remove the space between the = and 563. Still get the same error. Also tried
Select
*
From
ILT_ProductAssignment
Where
OrderNumber = '563'
Same thing? Can anyone identify what I've been doing wrong? Thanks
Line 2 implies the line containing the *. Do you have a hidden special character there, something invisible to the user? The only things that should be before the * is a tab or white space. Perhaps delete the white space and hit space 4 times instead of tab; does that do the trick?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 17, 2018 at 1:17 pm
Yes that worked!
Thanks so much!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply