Dear All,
I need the last date updated from two different tables i mean max(date). We will update in any one of the table at a time. Once updated i need to take the last updated date .
It may be either in table A or in Table B.
example.
Table A
Id Date
100 16-05-2014
101 20-05-2014
102 22-05-2014
Table B
Id Date
100 06-04-2014
101 26-05-2014
102 21-05-2014
I need the date from Table B (101 26-05-2014) last updated date....