Solution for the above question is
Associate the appropriate "Shipping Method" with each order based on its "Order_Priority".
Then combine the "Product Categories" information with the "Product Details" info (the headers in Product Details are product SKUs).
Finally, combine both datastreams to flag all orders which contained "Technology" items and were sent via "Freight". Mark those orders with "REVIEW" and all others with null.
