Hey Rabbit, Sorry for being so long replying, multiple projects, fires, pleases, etc.

And sorry for not posting the SQL. Your suggestion worked to a point. But I'm sure that you will probably spot what I'm doing wrong and it's something simple.

Here is the SQL:

...

Yes, the first field in each of the tables in the example is the record id. And forgive me for blundering, but attached is the SQL file to drop, create and populate the tables for this problem.

Rabbit, I am combining the fields from all four tables. When I make the name corrections and try to add your example, I keep getting errors of one type or another, mostly syntax.

Here is the SQL statement (from a view) I am...

I am new to SQL Server (2008 R2) and I am trying to create a view for use with a web app built with Dreamweaver.

Just to provide an example of what I am looking for, I want a listing of all the Clients who visited on 7/14/2009, and their most current address. I have seen some examples of using max, but they were incomplete and when I try to put them together using only two tables I can make it work, but when I try to do multiple tables...