Hi Sachin. Thanks for the feedback. I tried to run this query but I kept getting a 'missing operator' message. I took the T out right before WHERE rid...
The 2 tables are just subsets of the larger set. They were just to illustrate what the original table is and what the expected result should look like.