If you are trying to fetch the latest status per registrant, then you need to look at starting with an
SQL GROUP BY Statement[
^] to "put together" all the individual members status records. You can then return the member and their latest date by using the MAX aggregate function as a subquery. JOIN that to your status table and you can get just the rows you need from that. JOINing that to the rest of your data should be trivial.