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
)
是否要括号??
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 ALL ---少了个ALL
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
Msg 4104, Level 16, State 1, Line 1
无法绑定由多个部分组成的标识符 "BasicExpense.bOfficeId"。
Msg 4104, Level 16, State 1, Line 1
无法绑定由多个部分组成的标识符 "BasicExpense.bUId"。
((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 ALL
(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 as bPrice,sPaymentTime as bPaymentTime,sNumber as bNumber,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