Skip to Content
0
Jun 20, 2018 at 03:47 PM

how to union the results of multiple queries in xsjs and output it

194 Views

Dear All,

I need your help for the below scenario.

I need to output the result set based on union of two sql statemts. Can someone please let m know how to approach this in xsjs.

op4 = conn.executeQuery(select * (( select Select Name,rank from table3) union (select Select Name,rank from table3))order by rank desc;

Regards,

Kavana