I work with several dabases created by other users. (Oracle, Access, LibreOffice).
When I create a new database I can choose to work with my own “local” tables or link with any other through ODBC.
If I choose to link to a ODBC source, after that, I cannot create local tables.
If I choose to start with a new .odb I cannot get information from another source (ODBC).
Is it possible to make a query linking tables from different sources.