Ambigous Troulbe With Asp And Sun-asp

hi

I have a trouble with my ASP-script. It works fine on my microsoft server. But on the unix SUN-ASP-server there is a problem.

I am make an SQL-call where I have 2 ambigous fields (ie two identical from two different tables). It is no problem access the data, but when i am going to get the data it gives me an error.

It's like this:

SQL="Select usernames.*,team.* FROM usernames,team;"
set rs=conn.execute(sql)
(both usernames and teams has the field ID"

And now when i get data i noramlly use

id1=rs("usernames.id")
id2=rs("team.id")

But this xxx.yyy in rs DOESN'T work on the sun server compared to my Access-server.

How can i resolve this? Hope to get help on this ;)