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!
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!