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
by 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
-
huber
-
- Posts: 518
- Joined: Mon May 14, 2012 11:31 pm
Return to Programming with Servoy
Who is online
Users browsing this forum: Bing [Bot] and 23 guests