Posted by ZeldorBlat on 11/11/05 02:09

One way is to fetch the row as a numerically-indexed array and use the
numeric keys. The preferred (and much better) way is to alias the
column names in your query. So something like this:

CLNT_STATS_YTD.Vol_Collected as YTD_Vol_Collected
CLNT_STATS_MTD.Vol_Collected as MTD_Vol_Collected
CLNT_STATS_TD.Vol_Collected as TD_Vol_Collected

Then, when you fetch the result, you can refer to the columns as
YTD_Vol_Collected, MTD_Vol_Collected, etc.

[Back to original message]