cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IanP Frequent Visitor
Frequent Visitor

Join on key accross multiple rows & 3 columns in query

I am trying to join the related TSK_TASK_NUM by using the linkage that exists in the data as indicated in red in the picture, such that I can report in a single row the data from the first task in the sequence 69844 & the last related task 76334? Any ideas on how to join this data would be appreciated.

 

 Quotes.PNG

3 REPLIES 3
Community Support Team
Community Support Team

Re: Join on key accross multiple rows & 3 columns in query

Hi @IanP,

I could not understand what you want to calculate? Could you please post your desired result if possible?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
IanP Frequent Visitor
Frequent Visitor

Re: Join on key accross multiple rows & 3 columns in query

Thanks for your reply. I have now found the required link in our databases.

Community Support Team
Community Support Team

Re: Join on key accross multiple rows & 3 columns in query

Hi @IanP,

It's pleasant that your problem has been solved, could you please mark a repley to close this topic?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.