>> I need the ID of the first record and the status of the last record.
>What column makes a row first and last?
As an INNER JOIN is based on one single record, I would need two joins to achieve the results. After thinking more about it, I adjusted the structure and I now have everything I need in one table.