select d.开单姓名,e.审核员姓名,... from (select a.员工姓名 as 开单姓名,b.主键 from 员工资料表 a,货品请购单 b where a.员工编号=b.开单人编号 and ... )d left join (select a.员工姓名 as 审核员姓名,b.主键 from 员工资料表 a,货品请购单 b where a.员工编号=b.审核员编号 and ... )e on d.主键=e.主键 left join ...其他要显示的信息
select (select a.name from 员工资料表 as a where a.员工编号=b.开单人编号) as 开单姓名,(select a.name from 员工资料表 as a where a.员工编号=b.审核员编号) as 审核员姓名,... from 货品请购单 as b
select * from 员工资料表 a,货品请购单 b where a.开单人编号=b.开单人编号 and a.审核员编号=b.审核员编号
select d.开单姓名,e.审核员姓名,... from (select a.员工姓名 as 开单姓名,b.主键 from 员工资料表 a,货品请购单 b where a.员工编号=b.开单人编号 and ... )d left join (select a.员工姓名 as 审核员姓名,b.主键 from 员工资料表 a,货品请购单 b where a.员工编号=b.审核员编号 and ... )e on d.主键=e.主键 left join ...其他要显示的信息
from
(select a.员工姓名 as 开单姓名,b.主键 from 员工资料表 a,货品请购单 b
where a.员工编号=b.开单人编号 and ...
)d left join
(select a.员工姓名 as 审核员姓名,b.主键 from 员工资料表 a,货品请购单 b
where a.员工编号=b.审核员编号 and ...
)e on d.主键=e.主键 left join ...其他要显示的信息
from
(select a.员工姓名 as 开单姓名,b.主键 from 员工资料表 a,货品请购单 b
where a.员工编号=b.开单人编号 and ...
)d left join
(select a.员工姓名 as 审核员姓名,b.主键 from 员工资料表 a,货品请购单 b
where a.员工编号=b.审核员编号 and ...
)e on d.主键=e.主键 left join ...其他要显示的信息