Query support multiple SQL statements

[garywkau]

Hi everyone,

I am writing a query that is master-detail in principal. But need other data from other 2 tables. I wonder if I can construct the query so that it contains the result set of more than one SQL statement. Thank you for your kindly help.


Gary AU

 

[tehNellie]

You can, but you'd need to provide more detail on what you are trying to achieve.

The UNION [ALL] is one way of combining two SQL queries into a single output QUERY but there are other means of combining SQL subqueries in a single query.