SELECT max(p.datetstamp) OPENDENTAL_LASTD FROM procedurecode p 
union
SELECT max(p.datetstamp) OPENDENTAL_LASTD FROM patient p 
union
SELECT max(p.dateentryc) OPENDENTAL_LASTD FROM procedurelog p 