I have a table with a list of projects. I have another table that holds status updates for each of these projects. I am trying to select every project and it's most recent status update (based on the highest StatusUpdate_ID associated with that project).<BR><BR>SELECT p.*, su.* FROM Projects p, StatusUpdate su WHERE p.Project_ID=su.Project_ID(+) AND StatusUpdate_ID=(SELECT MAX(StatusUpdate_ID) FROM StatusUpdate WHERE p.Project_ID=su.Project_ID)<BR><BR>There are many projects with many updates, but I only get one record total, rather than one record for each project. The one record I get is the maximum StatusUpdate_ID. Can anyone see what I am doing wrong?