Skip to main content
1-Visitor
December 16, 2016
Question

Multiple SQL query

  • December 16, 2016
  • 3 replies
  • 1737 views

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

3 replies

1-Visitor
December 16, 2016

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.

5-Regular Member
December 28, 2016

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.

5-Regular Member
December 29, 2016

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.