Question:
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
