MySQL 查询优化: 使用 IN 子查询检索并排除空值

SELECT * FROM ygj_billsalesjilu WHERE ptypeid IN ( SELECT ptypeid FROM ygj_xiehe WHERE usercode = 'A9655(SBP+I)SK35' ) AND ptypeid IS NOT NULL;

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