SELECT
DATE(i.begin_date_time) AS vstdate,
a.hn,
a.an,
CONCAT(p.pname, p.fname, ' ', p.lname) AS ptname,
d2.name AS doctor_name,
ip.name as namedd
FROM ipt_nurse_oper i
LEFT OUTER JOIN doctor d2 ON d2.code = i.doctor
INNER JOIN ipt_oper_code ip ON ip.ipt_oper_code = i.ipt_oper_code
INNER JOIN an_stat a ON a.an = i.an
INNER JOIN patient p ON p.hn = a.hn
WHERE i.ipt_oper_code = 121
AND DATE(i.begin_date_time) BETWEEN '2026-09-01' AND '2026-10-30'
