On Mar 17, 1:40 pm, erobinso...@gmail.com wrote:
> I have 2 tables:
>
> deposit
> withdraw
>
> each table has a column named, updatetime, which is a timestamp type.
>
> How would I use a single select to pull the most recent updatetime
> from either table?
>
> i.e., select max(updatetime) from deposit,withdraw;
>
> Thanks,
> Erob

select max(updatetime)
from (select updatetime from deposit
union
select updatetime from withdraw)