Same table names within ADO.Recordset

[Psych0]

Hello everyone.

First of all: Sorry for my English.

I'm deal with Access, ADO (msado2), Visual Basic 6.0. I've got joinin' one table to itself (like this tabTable INNER JOIN tabTable As tabTable1 ON tabTable.ptrParent = tabTable1.Key) in my query.

I want get recordset "schema" like this:
tabTable.Caption
tabTable.Description
tabTable1.Caption
tabTable1.Description

I'm facin' a problem: there's no a propperty within a ADO-recordset wich sais me Alias-table name. It's only BASETABLENAME exist.

Please help me to get the "schema" (c. above) programmatically.

[VictorN]

SELECT 
	tabTable.Caption	AS TableCaption,
	tabTable.Description	AS TableDescription,
	tabTable1.Caption 	AS Table1Caption,
	tabTable1.Description	AS Table1Description
...

[Psych0]

Thank u for answer, Viktor.

It's not the answer I expected to recieve.

I'll try to rephrase the question.

Imagine the next task:
You've got a pointer to opened valid recordset. How to obtain an ailiases for all tables from source query? Not a 'source' or 'ActiveCommand.CommandText' from recordset but the aliases. Is it posible to achieve the goal.

P.S. I'm tryin' to realize following functioability:
An application reads the SQL-query (like "SELECT * FROM chain of tables..." or "SELECT tab1.*, tab2.Caption... FROM chain of tables). The application constructs a dialog that offer to any user to specify a complex filter. In any case the source query is unknown, until it had been read.

Is any smart decision exist? I can realize parsin' of a source query by I think it's not smart enough.