SELECT d.* FROM stock_hld_info d where d.MAIN_HLD_YN='Y' and (d.CERTIFTYPE,d.CERTIFNO) in (
SELECT c.CERTIFTYPE,c.CERTIFNO FROM stock_hld_info c where c.NO in (
'编号1','编号2'
)
)
mysql where in带2个参数的查询方式
最新推荐文章于 2022-11-02 15:00:20 发布