Get most recent date

[jovillanuev]

Guys,

Please take a look my script.
my object here is to get the most recent date from table 2.
what if the recent date from table 2 is less than the date from table 1?

Table1

Type-Date1
--------
1-2011-07-16
2-2011-07-16 
3-2011-07-10 
4-2011-07-10 

Table2

Type-Date2
--------
1-2011-07-06 
2-2011-07-07 
3-2011-07-01 
4-2011-07-01 
 
Select 
    min(Date2)
From Table1 as a
Left outer join table2 as b
on a.type = b.type
and date2 > date1


regards,
JOV

[Pgmer]

Is your script is giving any result? i could see where condition is missing in script. you want recent date only from table 2 ? what is the relation between table1 and table 2?

[jovillanuev]

The where clause condition is Date also. Yes from table2. the relation of table 1 and table 2 is the type.

[Pgmer]

If your object is to get most recent date only from table 2 Why cant u just do select top 1 coulumn order by column desc?