LEFT function not working

Question

LEFT function not working

businessintelligence2010

SSChasing Mays

Points: 640
More actions
June 22, 2009 at 10:18 am

#205774

Hello -
What is not right below? I am trying to pull a data from another table where 'Inncode' from tblOTSOrder = first 5 character from 'Site_Id' from tblSRO378.
select
tblOTSOrder.InnCode,
tblSRO378.Order
FROM tblOTSOrder
INNER JOIN tblSRO378
ON tblOTSOrder.InnCode = tblSRO378.left(Site_ID,5)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

businessintelligence2010 (6/22/2009)
Hello -
What is not right below? I am trying to pull a data from another table where 'Inncode' from tblOTSOrder = first 5 character from 'Site_Id' from tblSRO378.
select
tblOTSOrder.InnCode,
tblSRO378.Order
FROM tblOTSOrder
INNER JOIN tblSRO378
ON tblOTSOrder.InnCode = tblSRO378.left(Site_ID,5)

Should be:

select

tblOTSOrder.InnCode,

tblSRO378.Order

FROM

tblOTSOrder

INNER JOIN tblSRO378

ON tblOTSOrder.InnCode = left(tblSRO378.Site_ID,5)

businessintelligence2010 SSChasing Mays Points: 640 More actions · Answer 2

Thank you..but I get the following error:

Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'Order'.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Is Order the name of a column in the table? If so, put brackets around it, like this:

tablealias.[Order] -- Please note, I didn't use yout table name, short term memory isn't what it use to be

businessintelligence2010 SSChasing Mays Points: 640 More actions · Answer 4

Thank you very much...after tweaking few col names, it worked!! Appreciate your time.

businessintelligence2010 SSChasing Mays Points: 640 More actions · Answer 5

Lynn - One more q's for you. I need to add data from third table now. I need the following code to include in existing code so that I can get the result as a third column in my output.

select

HotelMstr.brand,

tblhoteltype.hotelName

from HotelMstr

inner join tblHoteltype

on HotelMstr.brand = tblHoteltype.hoteltype

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

NEI, Not Enough Information. At this point, please read the first article I have referenced below regarding asking for assistance. Without knowing the table definitions and how the four tables are related I can't answer your question from the short code snippets provided.

businessintelligence2010 SSChasing Mays Points: 640 More actions · Answer 7

Thanks Lynn for the links. I will try my best to explain it better.