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