How can I do this with out using Store Procedure or View.

Select * from tb_Task a Inner join (Select taskNo, max(beginDt) ‘beginDt’ From tb_task group by taskNo) b On a.taskNo=b.taskNo and a.beginDt=b.beginDt

I am using the Adpater model with the latest version of LLBLGen.

LLBLGen Pro doesn't support 'derived' tables at the moment, i.e. joining with a selectlist of another query.

However, what I don't understand is that you select data from another set which has a 1:1 relation with the parent set, as you join on the PK field (TaskNo, at least that's what I assume is the PK). I.o.w.: that info is already available in 'a', or am I missing/overlooking something?