SQL query in Dashboard or View

Hello guys,
does anyone know how can I create SQL query in Dashboard or View? Is that possible?

I want to use this query:
SELECT        APPROVALLOGM1.COUNTER, APPROVALLOGM1.FILE_NAME, APPROVALLOGM1.UNIQUE_KEY, APPROVALLOGM1.CATEGORY, APPROVALLOGM1.CURRENT_PHASE, APPROVALLOGM1.ACTION,
                         APPROVALLOGM1.DATE, APPROVALLOGM1.OPERATOR, APPROVALLOGM1.DELEGATE, APPROVALLOGM1.[GROUP], APPROVALLOGM1.COMMENTS, APPROVALLOGM1.NAME,
                         APPROVALLOGM1.OPERATOR_FULLNAME, APPROVALLOGM1.SYSMODTIME, APPROVALLOGM1.SYSMODUSER, APPROVALLOGM1.SYSMODCOUNT, APPROVALLOGM1.COMPONENT,
                         APPROVALLOGM1.REJECT_REASON, REQUESTM1.REQUESTED_FOR, REQUESTM1.AFFECTED_ITEM, REQUESTM1.PROBLEM_TYPE
FROM            APPROVALLOGM1 LEFT OUTER JOIN
                         REQUESTM1 ON APPROVALLOGM1.UNIQUE_KEY = REQUESTM1.NUMBER
Best regards,
Dino

Tags: