left_join.sql

select
  p.pkey || '-' || ji.issuenum AS issue_key
  ,ja.actionbody
from jiraissue ji
inner join project p
  on ji.project = p.id
left join jiraaction ja
  on ji.id = ja.issueid
  and actiontype = 'comment'
where p.pkey = 'TP';