34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT count(DISTINCT t.psn)
FROM Product t, QuotationAssignedsupplier q
WHERE t.isdeleted = '0' AND t.psn = q.psn AND q.sid = 'S0088'
OR PPN RLIKE '^M|^F|^O|^A|^Y'
--看看跟SQL一不一样
SELECT count(DISTINCT t.psn)
FROM Product t, QuotationAssignedsupplier q
WHERE t.isdeleted = '0' AND t.psn = q.psn AND q.sid = 'S0088'
OR PPN RLIKE 'MFOAY%'