Use aused() function to list all opened aliases. Do this before query running than after. Compare results of both calls - you will have list of all aliases opened during SELECT command running.
This method also useful to control form environment and close all extra opened aliases during form running.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.