query ใบสั่งยา

SELECT count(distinct o.vn) as cc
FROM opitemrece o LEFT join drugitems d on o.icode=d.icode
WHERE o.vstdate between '2025-03-01' AND '2025-03-31'
AND (o.an is null or length(o.an)=0) AND d.icode is not null

SELECT Count(DISTINCT o.order_no) AS cc
FROM opitemrece o
  LEFT OUTER JOIN drugitems d ON o.icode = d.icode
  LEFT OUTER JOIN ipt_order_no i ON o.an = i.an
  left outer join ipt a on o.an=a.an
WHERE a.dchdate BETWEEN '2025-03-01' AND '2025-03-31' AND (o.an IS NOT NULL OR
    Length(o.an) = 9) AND d.icode IS NOT NULL