Tablename.Fieldname in DataSet

[AJ]

I have a sql query with a join, for example something like this

SELECT Customers.CompanyName, Customers.ContactName ,
Orders.OrderDate,
Customers.CustomerID, Orders.CustomerID
FROM Customers INNER JOIN Orders ON
Customers.CustomerID = Orders.CustomerID

when i fetch the resultset of this query in a dataset, the dataset
resolves
it to Fieldnames and ignores the "Tablename." in front and
if there is a dupicate field (like Customers.CustomerID,
Orders.CustomerID)
it just puts a suffix of 1.

Now if i wanted to get the actual name of the field as i brought it out
from
Db (Tablename.Fieldname), can that be done from the datset
in which this resultset is fetched.

 

[William \(Bill\) Vaughn]

Add an "AS" operator to the column selector clause.

SELECT Customers.CompanyName AS CompanyName, ...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________