Does base suppor sql union statement?

for the following statement:

SELECT * FROM “Contacts” UNION SELECT * FROM “csv_contacts”

I get the message:
The given command is not a SELECT statement.
Only queries are allowed.

Is there a special way of handling this query or is UNION not supported?


The answer is here,

That link is invalid.

1 Like

Although my comment above is accurate, I’ve discovered that with LO it is sufficient to “Run SQL command directly” for UNION and UNION ALL commands. Click the SQL icon at the right side of the toolbar in the Query Design window to set this option.

Additionally, this LO version now accepts comments (/* comment */ or – comment) in the SQL editing window and now preserves white space in the SQL command.

Thanks. I created two views then called them using a UNION statement using the SQL icon as suggested and it worked.