how to display 2 fields w/ the same names (same database but different tables)???

[lindaklu]

I'm query from 2 tables that have the same field names.
How can I distinguish one from another when I do Response.Write??
I can't do Response.Write rs("table1.description")...
and I tried
str="SELECT DISTINCT table1.description as des1, table2.description des2 from mydb.table1, mydb.table2 where ... "
but the database I'm accessing is Progress Database and it doesn't recognize when I define in the select statement "table1.description AS des1"... please let me know if there's any other way to do this!!
Thanks in advance!

 

[Gabor Topor]

Hi,

Have you tried to use LABEL option like
select table1.description label "des1", table2.description label "des2" from table1, table2 ... ? It works in Data Dictionary.


Regards,
Gabor