use sro_vt_shard go select * from Tab_RefNest where dwTacticsID in ( select Tab_RefTactics.dwTacticsID from Tab_RefTactics where szDescString128 = 'ekteb al code bta3 al mob hena')