Union with QBSelect

Questions and answers regarding general SQL and backend databases

Union with QBSelect

Postby nevenam » Tue Feb 26, 2013 12:15 pm

Hi,
Do you plan to add the union operator to QBSelect? Is there a way to combine the result sets of select statements at the moment, besides using raw SQL statements?
Nevena
nevenam
 
Posts: 13
Joined: Tue Oct 09, 2012 4:53 pm

Re: Union with QBSelect

Postby rgansevles » Tue Mar 05, 2013 1:44 pm

Nevenam,

Servoy bases its sql generation on Hibernate which does not support unions.

You could try query with OR-ing 2 subselects to get the same result.

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1864
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Union with QBSelect

Postby huber » Wed Feb 21, 2018 9:33 am

Hi

Is this statement of QB not supporting the UNION operator still valid as per today? A small example with OR-ing would be helpful.
rgansevles wrote:Nevenam,

Servoy bases its sql generation on Hibernate which does not support unions.

You could try query with OR-ing 2 subselects to get the same result.

Rob

Regards, Robert
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 311
Joined: Mon May 14, 2012 11:31 pm


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 1 guest

cron