-
-
liuyt 小试身手Lv3
发表于2025-2-25 22:03
悬赏10
未解决
楼主
ABI查询功能实现，标黄部分动态拼SQL，需要传参数，根据枚举下拉拼接不同的SQL，枚举1拼接SQL1、枚举2拼接SQL2、枚举3拼接SQL3、
SELECT * FROM A LEFT JOIN B ON A.S = B.S WHERE A.Q = '' AND EXISTS (SELECT 1 FROM （select * from where a=?） ......) ORDER BY A.1,A.2,A.3
SELECT * FROM A LEFT JOIN B ON A.S = B.S WHERE A.Q = '' AND EXISTS (SELECT 1 FROM （select * from where a=?） ......) ORDER BY A.1,A.2,A.3
