cross apply

select a.ProjectID,c.* from BatchTask a cross apply (select * from TaskLog b where a.RsIndex=b.BatchTaskID) as c

同理，outer apply