Does anyone have any code to determine what tables and fields are being
returned in a select statement.

Ie.  select field1, field2 from table1, table2.

Has anyone written anything that will read in the select statement
and spit out the fact that field1 is in table2 and field2 is in table1?

I know that the field name is stored in the sqlda structure, but I can't
find where the table name is stored.  I assume that the code would have
to check the syscolumns and systables tables.

Any help would be greatly appreciated.
        Scott Deifik