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
shabeer shaik
NA
40
19.8k
how to update from 1 table to another
Dec 27 2012 10:40 AM
hallo Vulpes
I have a table in sql called tb1
the contents is something like this:
crse dist wintime winweight
cd 1400 67.6 60
cd 1600 71.2 58
sv 1400 69.0 59
in tbl2 in sql
crse dist partime winweight
cd 1400
cd 1600
sv 1400
I WANT TO AUTOMATICALLY UPDATE TBL2 PARTIME,WINWEIGHT WITH WINTIME ,WINWEIGHT FROM TBL1 WHERE CRSE AND DIST ARE THE SAME.
Reply
Answers (
5
)
Sql Queries
Finding 2nd and 4th saturdays and sundays in SQL proc or JS