SQL query on DataSet

  • Thread starter Thread starter PawelR
  • Start date Start date
P

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
 
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.
 
Back
Top