Servoy Forum

Hi

Are nested SELECTs like the following example possible with QueryBuilder?

Code: Select all

SELECT
   times.column_a,
   lessons.column_b
FROM (
   SELECT
      w.day_number,
      lt.start_time
   FROM
      table_x w
   INNER JOIN table_y lt
   ...
   INNER JOIN table_z z
   ...
   WHERE
      ...
         ) lessons
RIGHT OUTER JOIN table_t times
   ON ...

Regards, Robert