Hi

Actually i want if TransId of AccountId (1101) has record with AccountId 1210 with same TransId as of (1101) then that record should also be displayed.

If we link on AccountId...

• This reply was modified 5 years, 1 month ago by  jsshivalik.

Hi GrassHopper
  I have written below code . Is it ok
insert into tblTemp select  A.[No_],A.[DocNo_] from [Test] as A

where exists (Select No_ from tblTemp as B...