Dataset queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to return values from multiple tables in a dataset at the same time.
Is there a way to create inner join query to a dataset that has several
tables?

BR
Johanna Turku
 
Yes, what is the db you are connecting to? I'm sure people would be only too
happy to provide some sample statements.
 
Im using sql server. But the question was not about that. Sure I can do INNER
JOIN query to sql server but the problem is that i have a dataset that is not
connected to the database. It is returned by a webservice and the client-side
application needs to query the dataset using 2 or more tables. Is this
possible?

BR
Johanna
 
Sebitti,

I need to return values from multiple tables in a dataset at the same time.
Is there a way to create inner join query to a dataset that has several
tables?
Click to expand...


A join will return *one* table with everything in it, therefore the answer
on your question is in my opinion "No".

I hope this helps,

Cor
 
My situation is that I already have a dataset that has multiple tables in it.
The dataset is fetched from a web service. I need to query this dataset to
get a result that has values from 2 or more tables in the dataset.

So I want to get a join query not from database but from a dataset. Is this
possible?

BR
Johanna
 
Johanna,

You might be interested in the assembly I've been working on at
http://www.queryadataset.com. Besides INNER JOINS, it lets you perform
complex SQL SELECT statements including UNION, OUTER JOINS, GROUP BY,
HAVING, ORDER BY, sub-queries, aggregates, functions etc against the tables
in a dataset.

Thanks
Ad.
 
Back
Top