How can I do a SQL join on jiraissue and jiraaction?

Question

I'm trying to write a SQL script that will find all the actions a particular member of our staff has done.

When I do a join on ID it mixes results from different tickets.

Is Id not unique per ticket>

select
jiraaction.author,
jiraaction.actiontype,
jiraaction.actionbody,
jiraissue.id,
jiraaction.id,
jiraissue.reporter,
jiraissue.assignee,
jiraissue.creator,
jiraissue.summary,
jiraissue.description,
jiraissue.created,
jiraaction.created,
jiraaction.updateauthor,
jiraaction.updated

from jiraissue
join jiraaction
on
    jiraaction.id = jiraissue.id

Royce_1jiuan · Answer

Thanks, I'm not wedded to SQL, I just couldn't see any other way to see all the comments made across the system by an individual user.

Nic Brough -Adaptavist- · Answer

SQL is the worst possible way to report on jira data.

But if you insist, then it is important to understand that most Jira tables have an id that uniquely identifies a record in them (you don't need that in a proper database, but that's one of many reasons reporting this way is bad.  The Jira database is NOT a database, it's a data store).

For your query, you need to join on jiraaction.issueid = jiraissue.id