Join a subquery

[ArsenyYankovsky]

Hey,

I'm trying to do the following:

loukoum.
Select(columns).
From("employees").
Join(loukoum.Select("count(*)", "employee_id").From("tasks").GroupBy("employee_id"), loukoum.On("employee_id", "tasks.employee_id")).
OrderBy(loukoum.Order("count", loukoum.Desc))

Is it possible to do a join on a query?

[ArsenyYankovsky]

Ok, I figured that I can just pass the string with a subquery as a first argument like that:

loukoum.
Select(columns).
From("employees").
Join("(" + loukoum.Select("count(*)", "employee_id").From("tasks").GroupBy("employee_id").String() + ")", loukoum.On("employee_id", "tasks.employee_id")).
OrderBy(loukoum.Order("count", loukoum.Desc))