--update table_a set 字段=b.字段 from tabel_b where 限制条件
UPDATE TblInInvoiceDetail SET FBusinessNo = tblInvoiceFlow.FNo FROM tblInvoiceFlow WHERE TblInInvoiceDetail.[FBusinessNo]IS NULL AND TblInInvoiceDetail.FInvoiceFlowID = tblInvoiceFlow.[FId]
--update table_a set 字段=b.字段 from tabel_b where 限制条件
UPDATE TblInInvoiceDetail SET FBusinessNo = tblInvoiceFlow.FNo FROM tblInvoiceFlow WHERE TblInInvoiceDetail.[FBusinessNo]IS NULL AND TblInInvoiceDetail.FInvoiceFlowID = tblInvoiceFlow.[FId]