I have data in database looks like first table in the picture and need output looks like second table in the picture.
Barcodes can be repeat several times during the date range with multiple Transcode (Scan locations). To become a complete transaction, it must follow the series of transaction such as T2->T6->T7->T3. However any transaction could be missed. Here in my scenario, I need to find out missing T6 or T7 exactly look like a second table. I hope someone help me out with this problem.