• 日期: 2027-11-10
  • 标签: 常规

SELECT TONODE FROM TBLPRDOPBUSINESSRULERELATION WHERE OPNO ='G1220' AND PRODUCTNO = (SELECT PRODUCTNO FROM TBLWIPLOTBASIS WHERE BASELOTNO = 'GM08942502-01.02') AND PRODUCTVERSION = (SELECT PRODUCTVERSION FROM TBLWIPLOTBASIS WHERE BASELOTNO = 'GM08942502-01.02') AND FROMNODE ='START' AND LINKNAME = 'PASS'

SQL语句拼接: 使用子查询获取 PRODUCTNO 和 PRODUCTVERSION

原文地址: https://www.cveoy.top/t/topic/l3o0 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录