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

Multiple SQL query

Highlighted
Newbie

Multiple SQL query

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

Tags (1)
3 REPLIES 3
Highlighted

Re: Multiple SQL query

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.

Highlighted

Re: Multiple SQL query

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.

Highlighted

Re: Multiple SQL query

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.

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!