Table names in the SqlDataReader

  • Thread starter Thread starter Henke
  • Start date Start date
H

Henke

Hi
If I do a SELECT * FROM tab1 INNER JOIN tab2 ON tab1.id = tab2.id and both
the tab1 and tab2 has a field called Name, how can I differ each field from
the other one?

Thanks in advance
/Henke
 
Hi
SELECT tab1.* FROM tab1 INNER JOIN tab2 ON tab1.id = tab2.id would give the
value of Name from tab1.
Ibrahim
 
Back
Top