SELECT prob.PROBLEMID "Problem ID",
       prob.TITLE "Title",
       ownaaa.FIRST_NAME "Technician",
       longtodate(prob.REPORTEDTIME) "Reported Date",
       sdno.description "Notes" FROM Problem prob
LEFT JOIN SDUser ownsd ON prob.OWNERID=ownsd.USERID
LEFT JOIN AaaUser ownaaa ON ownsd.USERID=ownaaa.USER_ID
LEFT JOIN problemtonotes prono ON prob.PROBLEMID=prono.PROBLEMID
LEFT JOIN problemnotes sdno ON prono.NOTESID=sdno.NOTESID
ORDER BY 1