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
sathish
NA
263
0
Table comparison
Aug 9 2017 1:13 PM
Hi
I have two set of table like below
Table 1
Wills
23
Carte
25
Bart
31
Table 2
Scaret
23
Adert
25
So scenario is
If all Table1 values are available in Table 2 it should pass - Ex : T1=23,25 &T2=23,25
If more values are available in Table 2 than table 1 it should fail Ex:T1=23&T2=23,25
If column values are mismatch between both it should fail Ex: T1=23,25&T2=23,45
Kindly let me know the query to check this condition..without any ID column.
Thanks
Reply
Answers (
1
)
How to Execute old sql scripts only if there is any change?
Combine two select Queries