Need help to get the below logic

[pavandbs]

Hello All,

My result table should be when user select Dealer tagged, it should intersection of below 2 tables

i.e

Result
B
D
E

[saimahasan]

Do you need only values B,D and E to be shown??? If so then you can put an inner join and it will remove the values A and C

[pavandbs]

Hi,

Thanks for the reply. It is not script level. I need the result by set analysis.

Thanks

[Anil_Babu_Samineni]

Try to provide sample data which illustrates the Output and let us know the expected result