KB-34303: Grouping different tables on the same query

How can I display the fields of different tables in the same SQL query?

Solution:

To do so, use SQL’s UNION command. Thus, you must enable the E3Query’s SQL checkbox and type an SQL string as the one below:

SELECT field as title
FROM table1
UNION SELECT field
FROM table2