Hi NG!
With a Inner-Join SQL I get my datas in a DataSet.
In the table are the column Entry and Version.
Like this:
Entry Version
1 1
1 2
1 3
2 1
3 1
Now i would like to have just the newest version of each entry.
Entry Version
1 3
2 1
3 1
I tried to use the
DataTable.Select(MAX(Version), Entry)...
DataTable.Select(MAX(Version) GROUP BY Entry)...
But it does not work and I did not find some good help.
I would like the keep my Inner Join SQL without this MAX and Group by,
because of use in other locations
Thanks
Regards