How can I know the columns name for the following SELECT (programmatically) ?

[mesajflaviu]

How can I retrieve programmtically the name of the columns implied into a certain SQL, for instance:

SELECT * FROM table1, table 2 WHERE table1.id = table2.id;