Nested SELECTs in QueryBuilder possible?

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

Nested SELECTs in QueryBuilder possible?

Postby huber » Mon Feb 19, 2018 10:39 am

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
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 310
Joined: Mon May 14, 2012 11:31 pm

Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 4 guests