how to join worklog table and work log types tables of jira in sql servers?

[Nageswarara Rao]

how join two tables in jira using jdbc in jira?

[Udo Brand]

Hi Nageswarara,

I just saw you asked 33 questions so far. You haven't accepted a single answer as a correct one so far. Please do us all a favor and accept the answers as a correct one, which helped you or where you think they are correct.

please see also following discussion.

https://answers.atlassian.com/questions/153990/why-users-not-accepting-answers

thanks,

Udo

[Nic Brough -Adaptavist-]

See https://developer.atlassian.com/display/JIRADEV/Database+Schema#DatabaseSchema-Worklogs for the join part of the question.

My instincts sense another question behind this one though, with you mentioning jdbc? Could you tell us what your actual requirements are? Why you're asking this question?

[Udo Brand]

Nics answer is correct. But I'm curious, what do mean by 'work log types tables' ? I'm not aware of such (a) table(s).