--批量生成语句，执行即可。（接待单里面没有结账单号造成单子看不见）

select 'Update T_RECEIVE set F_CHECKOUTID = ''' + F_ID
+ ''' where F_ID = ''' + F_RECEIVEID + '''' from T_CHECKOUT where F_RECEIVEID in 
(
select F_ID from T_RECEIVE where F_ID in

(
select F_RECEIVEID from T_CHECKOUT where F_CHECKOUTID is null
)
)