SQL语句拼接:结合TBLPRDOPBUSINESSRULERELATION和TBLWIPLOTBASIS查询数据
SELECT TONODE FROM TBLPRDOPBUSINESSRULERELATION WHERE OPNO ='G1220' and PRODUCTNO = '11860U00G041G' and PRODUCTVERSION ='01' AND FROMNODE ='START' AND LINKNAME = 'PASS' UNION SELECT PRODUCTNO,PRODUCTVERSION FROM TBLWIPLOTBASIS WHERE BASELOTNO = 'GM08942502-01.02'
原文地址: https://www.cveoy.top/t/topic/l3qk 著作权归作者所有。请勿转载和采集!