the best way to exclude the value by joining of tables

[beck_bakytbek]

Hi Folks,

I have a question: there are 2 Tables

Tab_A

ID, Sales

A, 1

B, 2

D, 3

and

Tab_B

ID, Sales

A, 10

B, 12

C, 13

The expected output is:

Tab

ID, Sales

D,3

what is best way to exclude the values and still only D = 3

Thanks a lot

Beck

[sunny_talwar]

Once again... this is the script you added noconcatenate to...

Do you think Tab_B will concatenate to Tab_A here? even though they have different fields? B have only ID and A has ID and sales?

[its_anandrjs]

Yes it is different scenario good one