SQLite Forum

Not understanding a subquery - Some guidance?
Login
Which, of course, is also this relatively simple select:

```
   select r.ritm,
          task,
          t.ritm,
          max(ud) as ud
     from r 
left join t 
       on r.ritm == t.ritm
 group by r.ritm, t.ritm
;
```