Hi,
I switched from Access databases and ASP to sql-server and ASP.NET some time ago and now ran into a little difference. I am not quite sure if the difference is in ASP.NET or in sql-server.
When I open a dataset using a join-query, I am no longer able to refer to columns as in "tablename.columnname". Therefore, if I have a table Countries and a table Cities and they both have a Name column, when I join them together I don't know how to refer to one of them (Countries.Name or Cities.Name returns an error).
How can I do this?
Thanks a lot,
Nander
I switched from Access databases and ASP to sql-server and ASP.NET some time ago and now ran into a little difference. I am not quite sure if the difference is in ASP.NET or in sql-server.
When I open a dataset using a join-query, I am no longer able to refer to columns as in "tablename.columnname". Therefore, if I have a table Countries and a table Cities and they both have a Name column, when I join them together I don't know how to refer to one of them (Countries.Name or Cities.Name returns an error).
How can I do this?
Thanks a lot,
Nander