From this query it joins dt1 & dt2 based on unique columns but not joining the dt2 columns
for eg:Dt1 as Column A,ColumnB and Dt2 as ColmC,ColumnD output should be as ColumnA,ColumnB,ColumnC,ColumnD now output coming as ColumnA,ColumnB alone based on unique conditions
dtProj1Exp.AsEnumerable().Where(Function(row) EMPDT.AsEnumerable().Select(Function(r) r.Field(Of String)(0).ToUpper).Any(Function(x) x = row.Field(Of String)(4).ToUpper)).CopyToDataTable()