Joints DataBases and Accessing 2 tables at once

Question

So I got the SQL basic: SELECT A.*  B.* Where A.ID = B.ID; Now I need to access the data within the OleDbReader Object (it's an access database). I can get everything that is absolute (i.e. Client Address comes up as address and is the only column named so) but cannot access any duplicates (i.e A.Name - a clients name and B.Name - the sales man name)... I put it on the Reader[ A.Name ]  but it exclaims an error! HELP! How do I access the data withing the reader object (or even better the repeater object that is binded to it)? Thanks Boaz

Adam Erstelle · Answer

To ensure you are knowing the index value of a column you will have to specify each column instead of using the * eg: Select A.NameA.AddressA.StreetB.Name as SalesManNameb.Country from .......etc then when you are getting the values from your dataset use NameAddressStreetSalesManNameCountry or whatever values you have selected

S_Kiryazov · Answer

I'm not sure that there is a different one. I've always been using alias.

DakaBoaz · Answer

How do I know the Index Value? Trail and error? Just start counting and hope for the best? ... Surly there is some way the Reader object can get the sql Table1.A column (and distinguish it from Table2.A) which is in clear text. no? (p.s - I'll try the index value it is a good solution just like the Table.A as T1A sql solution... I am just sure there is a different one...)

kvreddy72 · Answer

try index value ex. Reader[2].ToSrring();

Joints, DataBases and Accessing 2 tables at once