View Single Post

   
  #1 (permalink)  
Old 03-20-2008, 01:47 PM
erobinson32@gmail.com
 
Posts: n/a
Default Select MAX time from multiple tables

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
Reply With Quote