I have the following two tables that i'm trying make a test as below:
User | transaction
User1 | transaction1
User1 | transaction2
User1 | transaction3
User1 | transaction 4
Case ID | 1st transaction | 2nd transaction | 3rd transaction
Case 1 | transaction1 | transaction 2 | transaction 4
My test involves checking if transaction 1,2 and 4 from table 2 are found in table 1 for the same user, and output the case id. It can happen that a user has multiple cases as well.
Appreciate any recommendations on how to best approach this.
Last seen: 8 months 5 days ago
Joined: 02/12/2019 - 07:44