KB-34303: Grouping different tables on the same query

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

Print Friendly, PDF & Email

Este artigo foi útil? Was this helpful?

Classificação média - Average rating 0 / 5. Count: 0

Leave a Reply

Your email address will not be published.Required fields are marked *