Database Retrieval Mysql And Asp

I have an sql statement like this executed with asp and mysql.

select * from table1, table2, table3

How can I read a specific field from a table when tables have same fieldnames.

So for example table1 and table2 have both a field named content.

What I would like to do is:

contenttable1 = recordset("table1.content")
contenttable2 = recordset("table2.content")

But then I get an error like item not found in recordset.

If i do this it works but i don't know which field I read from:

contenttable? = recordset("content")

I know that it works with Access but I can't get it working with MySQL.