多表关联查询
select c.SystemName as SourceSystemName,d.SystemName as TargetSystemName,m.ModuleName as SourceModuleName, t.ModuleName as TargetModuleName,
b.FileName,b.FileType,b.FileSize,b.FilePath,a.SendTime
from FileChange_Record a left join FileChange_File b on a.ID = b.RecordID
left join FileChange_System c on a.SourceSystemCode = c.SystemCode
left join FileChange_System d on a.SourceSystemCode = d.SystemCode
left join FileChange_SystemModule m on a.SourceModuleID = m.ID
left join FileChange_SystemModule t on a.TargetModuleID = t.ID
where c.SystemName='原系统名称' and d.SystemName='目标系统名称' and m.ModuleName='源模块名称' and t.ModuleName='目标模块名称'
b.FileName,b.FileType,b.FileSize,b.FilePath,a.SendTime
from FileChange_Record a left join FileChange_File b on a.ID = b.RecordID
left join FileChange_System c on a.SourceSystemCode = c.SystemCode
left join FileChange_System d on a.SourceSystemCode = d.SystemCode
left join FileChange_SystemModule m on a.SourceModuleID = m.ID
left join FileChange_SystemModule t on a.TargetModuleID = t.ID
where c.SystemName='原系统名称' and d.SystemName='目标系统名称' and m.ModuleName='源模块名称' and t.ModuleName='目标模块名称'
