Skip to content

Instantly share code, notes, and snippets.

@dorkness-io

dorkness-io/right_join.sql

Created April 9, 2020 15:07
Show Gist options
  • Save dorkness-io/311a62fd7c875fec9530980cfd3c944e to your computer and use it in GitHub Desktop.
Save dorkness-io/311a62fd7c875fec9530980cfd3c944e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
right_join.sql
select
p.pkey || '-' || ji.issuenum AS issue_key
,ja.actionbody
from jiraaction ja
right join jiraissue ji
on ja.issueid = ji.id
join project p
on p.id = ji.project
where p.pkey = 'TP';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment