Audit Comment 추출 SQL

SELECT A.username,
       D.name,
       C.name,
       B.filename,
       B.kingdom,
       B.issuetype,
       B.issuesubtype,
       B.linenumber,
       A.commenttext
FROM   db_ssc_2020.auditcomment AS A
       LEFT JOIN db_ssc_2020.issue AS B
              ON id = A.issue_id,
       db_ssc_2020.projectversion AS C,
       db_ssc_2020.project AS D
WHERE  B.projectversion_id = C.id
       AND C.project_id = D.id;