Hi,
This may be a very silly question, but it has me beat at the moment.
How do I select data from more than one table into a typed DataSet?
I added a typed DataSet to my project with two related tables, and I
specified the relationship between them.
What I need to do is execute a query like this:
SELECT a.col1, a.col2, b.col3
FROM a, b
WHERE a.col1 = b.col1
AND b.col4 IN (@list)
The list parameter is a string holding a comma separated (and quoted),
arbitrary length list.
Obviously I can only define the query on one of the tables in the
DataSet - but when I get results back, they only contain columns for the
one table. I.e. if I've defined the query on table a, I only get two
columns in the result.
I can see why this should be the case, but is there a way that I can get
a result that contains columns from both tables.
Sorry if this is really obvious and I've just missed it.
Cheers
Peter