I need to connect two tables and return a single value for each project. However, the tables have a one-to-many relationship.
The first table has a single record for each project.
The second table is a status history table and contains multiple records for any single project. This table stores project_id, status_change_date and status_code.
How can I select only the most recent status_change_date for each projects and then return only the associate status code for that project? My final report needs to be a listing of all projects and their most recent status code.
The first table has a single record for each project.
The second table is a status history table and contains multiple records for any single project. This table stores project_id, status_change_date and status_code.
How can I select only the most recent status_change_date for each projects and then return only the associate status code for that project? My final report needs to be a listing of all projects and their most recent status code.