Hi
I have two set of table like below
Table 1
Wills | 23 |
Carte | 25 |
Bart | 31 |
Table 2
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