TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
mohit ranjan
NA
51
0
Update in order by
Feb 25 2013 1:41 AM
Table 1
DataValue TokenIndex
AB NULL
TABLE 2
TokenIndex TokenValue
1 AB
2 ABAC
i want to update my table1 (TokenIndex) with the (TokenIndex) of table2 where table1 (DataValue) (sql LIKE) with (TokenValue)
TABLE 2 with longest string
EG. AB like like AB,and ABAC also but i want 'ABAC' TokenIndex (which is 2) to update in Token index of Table 1 against AB
i want retult
Table 1
DataValue TokenIndex
AB 2
Reply
Answers (
4
)
select distinct
Incorrect syntax near the keyword 'INNER'.