dorkness-io · April 9, 2020 15:04
diff --git a/inner_join.sql b/inner_join.sql
 select
  p.pkey || '-' || ji.issuenum AS issue_key
  ,ja.actionbody
 from jiraissue ji
 inner join project p
  on ji.project = p.id
 inner join jiraaction ja
  on ji.id = ja.issueid
  and actiontype = 'comment'
 where p.pkey = 'TP';
	select
	p.pkey \|\| '-' \|\| ji.issuenum AS issue_key
	,ja.actionbody
	from jiraissue ji
	inner join project p
	on ji.project = p.id
	inner join jiraaction ja
	on ji.id = ja.issueid
	and actiontype = 'comment'
	where p.pkey = 'TP';