SQL query on DataSet

[PawelR]

Hello Group,
I've dataSet with 3 tables. How to make Sql Querys with 1.join and 2. sql
function min, max :
- Select a,b,c from tab1 as t1 join tab1 as t2 on (t1.id1=t2.id) where
t2.id2<100
- Select a, max(b), min(c) from tab1 group by a
on the DataSet object

Thx PawelR

 

[Dmitriy Lapshin [C# / .NET MVP]]

Hello Pawel,

To the best of my knowledge, JOIN queries are not supported on datasets. As
for the aggregation functions, please check the documentation on the
DataColumn.Expression property.