Hi,

I have a data-set A with 3 columns x,z,date. I need to select the max date of x and y. Once I have the max date of dataset A I would like to join this with data-set B that has columns x and g.

What is the simplest and easiest method to do this in SQL server 05? Please provide SQL syntax.

Thanks.
Nijojo.