Create a table from a direct query

Hello yg_be,

The idea is to create a database, then extract it (or not → depending on the progress of my work and the Access features that I'm not very familiar with yet) into Excel to perform analyses. In any case, I would like this database to be permanently available in Access.

You can use a query like a table, and it will fetch the external data each time → that's what I would like, but I don't know yet how to save this query :-(

Surely something is escaping me :-(
I created this query, I named it. Now I would like to save it as a table so I can link it to other tables imported from the ERP in creation mode.

On the left (all Access objects) I have several categories:
- Tables (imported from ERP)
- Query (the new one I just created)

What is the difference between Table and Query?

why do you want to save your query as a table?
you can link a query to other tables.
a table contains data, a query does not contain data, it allows you to obtain data.
it would be simpler if you explained what you wanted to achieve, without using words like table and query.

Thank you for the explanation! I understand the difference better :-)

In the end, I think I'm going to create a query and use it in SQL mode (my code is already ready in Microsoft SQL Server). I'll just have to adapt the joins and functions (I see there are some differences, like CASE WHEN and IFF).

One more question, do you know what the code is to replace FULL OUTER JOIN in Access?