[odb-users] Subselects in View

Lukas Obermann obermann.lukas at gmail.com
Fri Mar 17 14:09:54 EDT 2017


Hi there,

I know that it is not recommended to do complex queries with odb, but I wonder if it is possible to get a simple subselect working in a view or somewhere else.

Like this simplified query:
SELECT table1.name, (SELECT AVG(score) FROM table2 WHERE table2.t_id = table1.t_id) as score FROM table1

Thanks!
Lukas



More information about the odb-users mailing list