Result of a DataSet as Parameter for another DataSet

ai762

Hi Everyone,
I would like to do the following:

I have a query like "select nr from table" which returns e.g.:

nr
1
2
5
9

Now I want to build a second query which should use the result of the first query like:

"select wurst from tablexy where key in ('1','2','5','9');"

Has anyone an idea how to do that??

Thanks a lot

Chris

mwilliams

Hi Chris,

I don't know that there's a way to use one dataSet's data for a parameter in another. I'll have to give it a try to see if I can figure it out. Would doing a union or something like that in the SQL or using a joint dataSet in BIRT to join on the "nr" key not work for your situation?