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
214.6k
compare two tables if tableb coloum is null repalce table a
Apr 5 2014 7:38 AM
I HAVE TEO TABLES LIKE..
TABLE_A
SNO NAME MOBILE EMPID
1 RAJU 9014494876 A12345
2 VAMSHI 9765432123 B12367
3 KARTHIK 986623456 C34567
TABLE_B
SNO NAME MOBILE EMPID
1 SRINU 970123454 D123489
2 RAJENDER 'NULL' B12367
3 KARTHIK 934642389 C34567
COMPARE TWO TABLE
A & B
EMPID AND IF TABLE B MOBILE FIELD '
NULL
' UPADATE TABLE A MOBILE TO TABLE B
i want o/p like table_b
SNO NAME MOBILE EMPID
1 SRINU 970123454 D123489
2 RAJENDER
9765432123
B12367
3 KARTHIK 934642389 C34567
plz write quarie ...................
Reply
Answers (
3
)
seperate by comma between values
CREATE DATABASE permission denied in database 'master'.