An obscure body in the SK system. The inhabitants call it Earth
Posts
7,957
Re: Get the max value of two different data in two different tables
I'm struggling with your English a bit as well (good effort, though ) so I'm not sure this is the answer you want but I think you're after this:-
Code:
Select ID, Max(Date), Name
From
(Select ID, Date, Name From Table1
Union
Select ID, Date, Name From Table2)
Group By ID, Name
The inner query 'combines' the two tables as HoneyBee suggested. The outer takes that combined table and returns you the highest date for each ID and Name combination.
The best argument against democracy is a five minute conversation with the average voter - Winston Churchill
Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd
Reply With Quote
) so I'm not sure this is the answer you want but I think you're after this:-