Hi all,

I've to return only 1 field with the minimum value coming from 2 tables:

select min(table1.datetimex) as mindate1, min(table2.datetimex) as mindate2
from table1 left join table 2 on table1.id = table2.id where table1.id = 123
or table2.id = 123

In fact I've to check the minimum date if a record has been created in
table1 or table2.

I've tried min(table1.datetimex, table2.datetimex) as mindate but it doesn't
work.

How can I do that ?

Also if there is nothing in table1 and something in table2, do I have a
result ?

Thanks for helping

Bob