Sql Server 2008, I try to use Jira, I have two table and I have some data like this;
In this example ID=16554 is a
Main Task. 16555 and 16556 are
Sub Tasks of 16554. As you can see in
JIRAISSUE ,main task and all sub tasks are an issue. And they connected in
ISSUELINK table, in
I try to write a query like this but I failed. I try to find a result like this ;
As you can see in the picture, What I want is; showing one row based all main tasks and their sub tasks.
I can't find the right query for this. How can I do that?