sathish

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 

Answers (1)