SELECT t.thedate as "Date",
CONCAT( "",demo.demographic_no,""
) AS "eChart" ,
t.thesubject as "Subject", t.themessage as
"Message",
CONCAT(demo.last_name,", ",demo.first_name) as "Patient"
FROM messagetbl t
JOIN msgDemoMap m ON t.messageid = m.messageID
JOIN demographic demo ON m.demographic_no = demo.demographic_no
WHERE (NOT LENGTH(TRIM("{num}")) OR m.demographic_no = "{num}")
AND
(t.themessage LIKE "%{searchword}%"
OR t.thesubject LIKE "%{searchword}%"
)
ORDER by t.thedate DESC