In MS Excel, using ODBC, I can join multiple Sheets of an .xlsx in a single Query, using ODBC SQL syntax - to create a new Sheet with the combined values. There is no pasting involved, so that - when the underlying Sheets are updated - the new, combined Sheet reflects that change.
Is this possible in LO ?
If not, can I view and edit a native LO database table using Calc? That is, view, edit, and format the table data as if it were a Calc Sheet? But with the data maintained in the LO database table - no pasting involved.