SELECT data from DataSet tables (INNER JOIN)

[Frank Uray]

Hi all

I have a DataSet with 2 tables.
Now I want to select data like a INNER JOIN from these tables.

In SQL Syntax I would write:
SELECT *
FROM table1 t1
INNER JOIN table2 t2
ON t1.f1 = t2.f1
WHERE t2.xy = 'search'

How do I select data like this from a DataSet ?

Thanks for any comments

Best regards
Frank

 

[sloan]

You can't.

The .Select function of a ds.Table is very basic.

...

If you have 3.5, then you can look at LINQ.