Comon TSQL1
select g.*
from tHE_Move g
inner join tPA_SetDocType d on g.acDocType = d.acDocType and d.acType = 'P'
inner join tHE_MoveItem p on g.acKey = p.acKey
inner join tHE_SetItem m on p.acIdent = m.acIdent
select g.*
from tHE_Move g
inner join tPA_SetDocType d on g.acDocType = d.acDocType and d.acType = 'P'
inner join tHE_MoveItem p on g.acKey = p.acKey
inner join tHE_SetItem m on p.acIdent = m.acIdent