Hello!

Is it possible to give the result from the first SQL to the next? For example. My first SQL select all article where the sales volume is greater then 30.000 EUR

SELECT * FROM ARTICLE WHERE SALES_VOLUME >= 30.000;

Now I want to work with the result / data from SQL1 in my next SQL (SQL2). For example.... something like:

SELECT FIELD1, FIELD3 FROM "SQL1" WHERE FIELD4 = "ABC"

I want to do another query / selection on the results from SQL1. Is that possible? If yes, how?

Thank you in advance for your answer!


Best wishes,

Marc Geldon