MYSQL Query

[eluser]missionsix[/eluser]
I think you might be coming at it the wrong way then. Try to select from the history table first, and join the member. Select a distinct customerID from the table, join the member on that customerID and order by the creation date as you have now. Since you have more than one history note, this will give you the latest notes and return the associated member to that history note.