select a.*,b.* from a,b, (select nrow_id,max(date) max_date from b group by nrow_id)) c where a.row_id=b.nrow_id and b.n_rowid=c.nrow_id and b.date=c.max_date
select a.*,b.* from a,b where a.row_id=b.nrow_id and b.date=(select max(date) from b where nrow_id=a.rowid);
from a,b, (select nrow_id,max(date) max_date from b group by nrow_id)) c
where a.row_id=b.nrow_id and b.n_rowid=c.nrow_id and b.date=c.max_date
from a,b
where a.row_id=b.nrow_id
and b.date=(select max(date) from b
where nrow_id=a.rowid);