Lorenzo Thurman wrote:
I have three tables using date fields. I want to retrieve the oldest date contained in the tables. Can someone show me an example of a query that would do that?TIA
I think I have it, but if anyone has any comments, I'd appreciate it: select min(old) as oldest from (select distinct min(create) as old from tab1 UNION select distinct min(time_now) as old from tab1 UNION select distinct min(create_time) as old from tab2)
