在insert into语句中使用select

INSERT INTO t_VoucherEntry ([FBrNo],[FVoucherID])  VALUES  (20,(select FNext from t_Identity where FName='t_voucher'))
原文地址:https://www.cnblogs.com/glj1203/p/1865595.html