大佬们,公式如下:
SQL("123","select FConsignAmount from ICStockBillEntry where FInterID =(select FInterID from ICStockBill where FBillNo = '" + $C2 + "') and FEntryID = '" + $B2 + "')",1)
大佬们,这个写法该怎么改
SQL("123","select FConsignAmount from ICStockBillEntry where FInterID =(select FInterID from ICStockBill where FBillNo = '" + $C2 + "') and FEntryID = '" + $B2 + "'",1)
SQL("123","select FConsignAmount from ICStockBillEntry where FInterID in (select FInterID from ICStockBill where FBillNo = '" + C2 + "') and FEntryID = '" + B2 + "')",1)