Loading

Table comparison

sathish

9y865

Hi

I have two set of table like below

Table 1

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Gokhul Varman9y ago
Accepted answer
Please refer the link for more detailed answer:https://www.devart.com/dbforge/sql/datacompare/compare-sql-server-table-data.html
-1