SELECT prob.PROBLEMID "Problem ID",
       prob.TITLE "Title",
       probdesc.FULL_DESCRIPTION "Description",
       catadef.CATEGORYNAME "Category",
       subcatadef.NAME "Subcategory",
       itemdef.NAME "Item",
       orgaaa.FIRST_NAME "Reported by",
       ownaaa.FIRST_NAME "Technician",
       rc.rootcause "Root Cause",
       impactdef.NAME "Impact",
       solwork.DESCRIPTION "Workaround",
       solres.DESCRIPTION "Solution",
       longtodate(prob.REPORTEDTIME) "Reported Date",
       longtodate(prob.CLOSEDTIME) "Closed Date",
       statdef.STATUSNAME "Status" FROM Problem prob
LEFT JOIN SDUser orgsd ON prob.ORIGINATORID=orgsd.USERID
LEFT JOIN AaaUser orgaaa ON orgsd.USERID=orgaaa.USER_ID
LEFT JOIN SDUser ownsd ON prob.OWNERID=ownsd.USERID
LEFT JOIN AaaUser ownaaa ON ownsd.USERID=ownaaa.USER_ID
LEFT JOIN CategoryDefinition catadef ON prob.CATEGORYID=catadef.CATEGORYID
LEFT JOIN SubCategoryDefinition subcatadef ON prob.SUBCATEGORYID=subcatadef.SUBCATEGORYID
LEFT JOIN ItemDefinition itemdef ON prob.ITEMID=itemdef.ITEMID
LEFT JOIN ProblemResolution probResol ON prob.PROBLEMID=probResol.PROBLEMID
LEFT JOIN ImpactDefinition impactdef ON probResol.IMPACTID=impactdef.IMPACTID
LEFT JOIN ProblemToDescription probdesc ON prob.PROBLEMID=probdesc.PROBLEMID
LEFT JOIN SolutionToWorkAround probwork ON prob.PROBLEMID=probwork.PROBLEMID
LEFT JOIN Solution solwork ON probwork.SOLUTIONID=solwork.SOLUTIONID
LEFT JOIN SolutionToResolution probres ON prob.PROBLEMID=probres.PROBLEMID
LEFT JOIN Solution solres ON probres.SOLUTIONID=solres.SOLUTIONID
LEFT JOIN problemresolution ps ON ps. PROBLEMID=prob.problemid
LEFT JOIN StatusDefinition statdef ON prob.STATUSID=statdef.STATUSID
LEFT JOIN RootCause rc on rc.problemid=prob.problemid