>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!
Mike,
I am not sure I understand what you want.
You just want to update records in StatusHistory with new date and status, you want to insert new records in that table with new date and status or you want to update member's info for these which are already in StatusHistory and Add new records for these which are not there. Can you post some data and desired result?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.