Displaying combined table results with ASP and MySQL

Hi,

I use MySQL and ASP. I have two tables with a common field. When I write the following SQL code to MySQL gives the right results to me.

select * from sale,atlasantalya where(atlasantalya.urunkodu=sale.Evno)

But when I try to display the results with ASP, I always get "Object doesn't support this property or method" error no matter I make it with RecordSet or conn.Execute

Can anyone give me an idea about the possible reasons for this?

Thanks

Ceyhun

Are you sure your query is the problem?
What happens if you simplify your query?

select * from sale,atlasantalya

If you still get errors then your query is not the problem.