SQLite Forum

All,

So this works as expected:

select r.ritm, x.ritm, x.task, x.ud
from r r 
left outer join 
(
   select ritm, task, max(ud) ud
   from t
   group by ritm
) x on r.ritm = x.ritm

but can someone explain why this query doesn't work?

select * from r
left outer join t on r.ritm =
(select ritm from t where t.ritm = r.ritm order by date(ud) desc limit 1);

sqlite supports limit clause, left outer joins... does it support correlated subqueries?  I thought so.

Thoughts?

Thanks,
Jeff