Hi,
I am in a specific trouble!
I have one summary query with the following fields (query1):
Request Number, Version, SumOfProcessing, SumOfReview
Another query with (query2):
Request Number, Version, Processor, Reviewer, Processing time, Review time
My objective is to create another query with:
Request Number, Version, Processor, Reviewer, Processing time, Review time, PTime, RTime, Ptime remaining, Rtime remaining
Basically, all data from query2 and additionally PTime, RTime, Ptime remaining, Rtime remaining.
PTime should have the data from SumOfProcessing and RTime should have the data from SumOfReview from query1. PTime remaining and RTime remaining should have the difference between Processing time and PTime and Review time and RTime.
All rows from the query2 should be there. Where there is SumOfProcessing and SumOfReview data for corresponding Request Number and Version the PTime and RTime fields will be populated else, the value would be zero.
Please help me with the best solution.
For an example:
Ticket Version Processor Reviewer Processing_time Reviewing_time Status USDP-0001 1 Basab,Aditi Anindya 4 2 Assigned
USDP-0001 2 Anindya,Aditi Shukla 2 1 Assigned
USDP-0002 1 Basab Shukla 6 2 Delivered
USDP-0003 1 Ram Shaym 8 2 Assigned
Ticket Version SumOfProcessing SumOfReview USDP-0001 1 3
USDP-0001 2 2 1 USDP-0002 1 3 1
Output needed:
Ticket Version Processor Reviewer Processing_time Reviewing_time PSpent RSpent PTime remaining RTime remaining USDP-0001 1 Basab,Aditi Anindya 4 2 3 0 1 2 USDP-0001 2 Anindya,Aditi Shukla 2 1 2 1 0 0 USDP-0002 1 Basab Shukla 6 2 3 1 3 1 USDP-0003 1 Ram Shaym 8 2 0 0 8 2
Regards,
Basab