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
JAYRAM
NA
272
213.9k
COMPARE TWO TABLES AND REPLACE TABLE B COLOUM DATA TO .....
Nov 1 2013 5:50 AM
i have two tables
A & B
table_A
SNO NAME FATHER NAME MOBILE ADDRESS
EMPID
1 SHASHI RAJESH 9346543215 HYDERABAD
19765
2 RAMU PRAVEEN 7894532155 HYD
1954
3 SRINU VAMSHI 8765432345 HYD
19763
table_B
SNO NAME FATHER NAME MOBILE ADDRESS
EMPID
1 SHASHI VARD RAJESH VAR 9014494765 HYDERABAD
19765
2 PRAVEEN SHYAM 8985500166 HYD
19543
3 SRINU SRINU 8985500166 HYD
19763
both tables a & b have same EMPID COLOUM but different data ............
using table_B COULOUM EMPID compare table_A COLOUM EMPID REPLACE table_B NAME ,MOBILE COLOUM DATA TO table_A NAME ,MOBILE
I want output like this
table_A
SNO NAME FATHER NAME MOBILE ADDRESS EMPID
1
SHASHI VARD
RAJESH
9014494765 HYDERABAD 19765
2 PRAVEEN
PRAVEEN
8985500166 HYD 19543
3 SRINU
VAMSHI
8985500166 HYD 19763
Reply
Answers (
2
)
Help in delete & update query
select houseno ....orderedby house no