select语句的问题
select T_warhouse.Warnumber as Warnumber,T_manager.managernumber as manager,T_manager.managername as managername,T_part.Partype as Partype
into #temp2
from T_warhouse left outer join T_manager on T_warhouse.Warnumber=T_manager.Warnumber
left outer join T_part on T_manager.Warnumber=T_part.Warnumber
select distinct * from #temp2
请问这两个select语句怎么合成一句呀!!
------解决方案--------------------你的什么意思?
你的第一句造了#temp2
你的第二句是查询#temp2
------解决方案--------------------这样就可以了[code=sql
select * from
(select T_warhouse.Warnumber as Warnumber,T_manager.managernumber as manager,T_manager.managername as managername,T_part.Partype as Partype
[code=sqlfrom T_warhouse left outer join T_manager on T_warhouse.Warnumber=T_manager.Warnumber
left outer join T_part on T_manager.Warnumber=T_part.Warnumber
)][/code]
------解决方案--------------------select
distinct T_warhouse.Warnumber as Warnumber,T_manager.managernumber as manager,T_manager.managername as managername,T_part.Partype as Partype
from T_warhouse left outer join T_manager on T_warhouse.Warnumber=T_manager.Warnumber
left outer join T_part on T_manager.Warnumber=T_part.Warnumber