I have three tables...

T1 has fields objID, CustInfo, LastEditDate
T2 has fields objID, CustAddr, LastEditDate
T3 has fields objID, Notes, LastEditDate

T1, T2, and T3 are related by objID for use in an object-oriented UI based in .Net... Each row in each table is linked to the others by objID

So, an object in my OO code obviously may write to one or all tables when it saves. Certain parts of the object may save in T1, or T2, or T3. When they do, they write the current datetime in the LastEditDate field of the particular table they're saving into...

Anyhow, I want to have a query resultset that look like this...

CustInfo CustAddr Notes Latest_LastEditDate
.
.
.

Where each object (unique objID) has one row containing the CustInfo field, the CustAddr field, the Notes field, and then (the kicker!) the most recent of the LastEditDate fields...

Thanks in advance!