AnsweredAssumed Answered

ExecuteSQL - search on 2 tables and combined sorted results

Question asked by fmdataweb on Jun 15, 2015
Latest reply on Jun 15, 2015 by fmdataweb

I've used ExecuteSQL in the past to do a simple search for records in a single table.

 

I now have a situation where I would love to be able to use ExecuteSQL to search for records in 2 different tables and combine the results together and sort them - I'm not even sure if this is possible.

 

I have 2 tables: MessagesIn and MessagesOut and I would like to do a search for records in both tables then combine the results and sort by the timestamp field so they are in order.

 

Does anyone know if this is possible and what the syntax would look like?

Outcomes