Hi all

This kind of query should be common yet I often seem to break it.

Two tables

Members, StatusHistory.

Status history has the member id the status and the date of the change.

I want to grab member info and the current status and change date as of this moment for each member.

Please help.

Thanks!