SQL & PL/SQL

Hi All,

I have a query which has 4 tables. I want to capture max record of a date column from 3 tables.

Eg:

SELECT 1
FROM parties_tbl a,
     location_tbl b,
     siteuses_tbl c
     contacts_tbl d
WHERE ----
and ---
;

All the above tables has who columns(creation_date,last_update_date,last_updated_by,last_updated_login). I want to capture the latest updated date if either parties_tbl or locations_tbl or contacts_tbl gets updated. For now, I am thinking I can use a union and capture individual max(last_update_date) inside a subquery and do a max outside of the union to get the latest updated date. But this might not be a better way in performance stand point.

Any suggestions are appreciated.

Thanks!