cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can change your system assigned username to something more personal in your community settings. X

Multiple SQL query

gvignesh
1-Newbie

Multiple SQL query

Is it possible to have multiple SQL queries in single service?

3 REPLIES 3

I've never used SQL like services, but for sure you can have three subservices which does the SQL Queries and a wrapper service which calls the other three.

supandey
19-Tanzanite
(To:gvignesh)

Hi Guru, any specific reason why you want to put 3 SQL statements in a single service? Sure it is possible but overloading a functionality should be used wisely.

jamesm1
5-Regular Member
(To:gvignesh)

As Carles said, you can create 3 SQL Queries and a wrapper service to call all three, but you would only be able to return the results of one. If you are intending to join the tables in memory, you can use infotable functions such as Intersect and Union to join the results together.

Top Tags