>When we execute a select sql statement, the tables used by the select remain open. Is there a way to clean that ? And keep the ones that were already open before the select ?
>
You can use AUSED() function to get the list of open tables before and after select and closed the ones that are not in the first list.
--sb--