Returning Values Referenced by Initial Value from the Same Table Using Recursive Queries and UNION ALL

Retrieving the Most Recent Transaction Result from Two Tables Using SQL