FExplanation varchar(255) default(' ') )
go
insert into #TmpBillCheckList( FExplanation )
select a.FExplanation
from t_rp_newReceiveBill a
inner join t_rp_arbillofsh c on a.FBillID=c.FBillID
join t_rp_contact b on a.FBillID=b.FBillID
left join t_currency cur on a.FCurrencyID=cur.FCurrencyID
left join t_item i on a.FCustomer=i.FItemID
left join t_item ii on a.FDepartment=ii.FItemID
left join t_item iii on a.FEmployee=iii.FItemID
left join t_user s on a.FPreParer=s.FUserID
left join t_user t on a.FChecker=t.FUserID
Left join t_settle x1 on a.FSettle=x1.FItemID
Left join t_rp_systemenum x2 on a.FBillType=x2.FItemID
Left join (select v1.FVoucherID,v1.FNumber,v2.Fname FName from t_voucher v1
inner join t_vouchergroup v2 on v1.FGroupid=v2.fgroupid)v on b.FVoucherID=v.FVoucherID
where 1=1 and (c.FID_SRC=0 or c.FClassID_SRC not in (1000000,1000002,1000003,1000004,1000005,1000014,1000021,1000022,1000500,1000501,1000502,1000503,1000520,1000521,1007140,1000016,1000018,1000511,1000510)) and a.FRp=1 and a.FPre in(0,-1)
and b.FType not in(8,9) and a.FCheckStatus<>1
and a.FItemClassID in (1)
and (b.FStatus & 1)=1
and (b.FStatus & 16)=0
and i.FNumber>='01.BTC125'
and i.FNumber<='01.BTC125'
and a.FCurrencyID=1000
go
drop table #TmpBillCheckList
sql 代码如上
问题是当前执行报如题错误，
如果删除一行left join 对查询数据结果没有影响，执行就不会报错了
