Thanks for Help,

but this query provide me the details from both the table. I want just like macro we do in excel. compare the two table and update the...

Compare two table:-

There are numbers of columns in table 1 and table 2, but i want to compare four columns of this two table (i.e Chartnumber,DOS,CPT,Amount). If columns of table...

SHumphrey_66 (11/30/2010)

I would not use this method you will get false/positives...

Thanks for your Help but I want something different.

Table 1 has 10 columns and table two has 15 columns. I want four columns of table 1 i.e OldAr (Chartnumber, DOS,CPT...