62,074
社区成员
发帖
与我相关
我的任务
分享
--你联合时,需要字段数量相同,类型一样。
select
bPrice,
bPaymentTime,
bNumber,
Office.oName as OfficeName,
UserInfo.uName as UserName
from
BasicExpense left join Office
on
BasicExpense.bOfficeId=Office.oId --这里的联合条件应该给错了。
left join
UserInfo
on
BasicExpense.bUId=UserInfo.uId--
where
bPrice between 500 and 6000
union
select
sPrice,
sPaymentTime,
sNumber,
Office.oName as OfficeName,
UserInfo.uName as UserName
from
SpecialExpense left join Office
on
BasicExpense.bOfficeId=Office.oId --
left join
UserInfo
on
BasicExpense.bUId=UserInfo.uId--
where
sPrice between 500 and 6000
--你执行单条语句时,可以吗?
(
select bPrice,bPaymentTime,bNumber,Office.oName as OfficeName,UserInfo.uName as UserName
from BasicExpense left join Office on BasicExpense.bOfficeId=Office.oId left join UserInfo on BasicExpense.bUId=UserInfo.uId
where bPrice between 500 and 6000
)
UNION
(
select sPrice,sPaymentTime,sNumber,Office.oName as OfficeName,UserInfo.uName as UserName
from SpecialExpense
left join Office on BasicExpense.bOfficeId=Office.oId
left join UserInfo on BasicExpense.bUId=UserInfo.uId
where sPrice between 500 and 6000
)
是不是要括号????
select bPrice,bPaymentTime,bNumber,Office.oName as OfficeName,UserInfo.uName as UserName
from BasicExpense left join Office on BasicExpense.bOfficeId=Office.oId left join UserInfo on BasicExpense.bUId=UserInfo.uId
where bPrice between 500 and 6000 UNION
select sPrice,sPaymentTime,sNumber,Office.oName as OfficeName,UserInfo.uName as UserName
from SpecialExpense left join Office on BasicExpense.bOfficeId=Office.oId left join UserInfo on BasicExpense.bUId=UserInfo.uId
where sPrice between 500 and 6000