yeah, that's how I originally wrote the query but when the trans_status changed it would bring back 2 rows for the same prod_id.