Accessing two OleDb 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

madinewala · Answer

Boaz DataReader can only be used for forward reading of data but not accessing the data within it. Inorder to access it you must replace your datareader with a dataset. For your requirement try using the DataSet to access the data from both the tables i.e A.Name and B.Name. Within your dataset you could then get the data either using the column name or using the ID. HTH irfan

DakaBoaz · Answer

Right but I did in the program - I got the SQL righjt trust me (I do get returns on the columns that dont have name conflicts)... But thank you for noticing...

zseml · Answer

You aren't adding a FROM clause in that statement.