Query a table using the result of previous query

Hello everyone,

I have multiple complex queries to do and in order to not get lost I would like to chain simple queries one after the other. For instance, I have a first big query A which gives me a nice table as result that I store in ResultA,I would like then to run my second query B on the stored variable ResultA that I could have in a separate script to gain more visibility. I really found no information on querying database from stored variables/tables (except for "Where queries") or how to chain them.

Hope I managed to explain it not too badly. Please let me know if you need any details. Thanks in advance for your help and support. Regards, Marc.