INNER JOIN on a DataSet

Question

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?

compuwiz02 · Answer

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.