ตาราง Diag IPD

SELECT
  i.`name`, i.icd9cm, i.icode,
  n.`name` AS nd_name,
  n.unit,
  n.nhso_adp_code,
  i.price,
  p.group1_ipd_price, p.group2_ipd_price, p.group3_ipd_price
FROM
  ipt_oper_code i
  LEFT OUTER JOIN nondrugitems n ON n.icode = i.icode
  LEFT OUTER JOIN pttype_item_price_summary p ON p.icode = i.icode
WHERE
  i.active_status = 'Y' AND i.icode <> ''
  AND i.`name` LIKE '%intubation%'
LIMIT 0, 15