Loading

INNER JOIN on a DataSet

compuwiz02

Hello, I am trying to do an INNER JOIN with 2 tables in my DataSet. One of the tables comes from an SQL source, however the second one is being populated from a file, so i cannot just do an inner join at the SELECT string level. Anyone has any idea how to do an INNER JOIN inside of a DataSet?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

compuwiz0222y ago
I meant Left Join, but i think that i found how to do it. I think that if i use a DataRelation object, i should be able to do it that way. I will post a working INNERJOIN Method if i get it to work.