full_outer_join.sql

select
  p.pkey || '-' || ji.issuenum AS issue_key
  ,ja.actionbody
from jiraaction ja
full outer join jiraissue ji
  on ja.issueid = ji.id
join project p
  on p.id = ji.project
where p.pkey = 'TP';