selection on selection

[patweb]

Is its possible to run a query on another query ?

I have a table import filled with data from uploaded files.
On these data are several analyses queries running.

I would like to run these analyses queries not on the table import but on a query (select * from import where file_id = $file_id) which select out of this table the rows where the file ID is equal to the last uploaded file. If not he will select all the data from this import table.

 

[UMPADev]

Yes it is possible! Just and your query into the loop that is importing the data. Run the query after you run the import. Then it will go to the next import.