I have a PostgreSQL database, with only
SELECT permissions. In this DB there are two tables with the same structure (the same columns).
I need to write several query in each table and join the results.
There is a way for writing a query like this one?
SELECT field1, field2, field3 FROM table1 AND table2 WHERE condition;
Select from 2 tables. Query = table1 OR table1 + table2 have no answer and it is not my question.