This Is Probably Pretty Easy....

Hey guys, I'm new to reporting services and I just need to throw together a report that references multiple datasources. I can query up all my info individually, but I need to write a query that says,



Select ProductName,ProductId from datasource 2

where ProductId = @ProductIdFromDataSource1



I can get this to work, but if my query from datasource 1 returns 10 productID's, this will only return the productname from the first ProductID, 10 times. I believe that's because I'm using the First() aggregate function. Is there another function I can use that doesn't do that, or some way I can reference each field individually?



Just to clarify a little more, here's what I want:






Code Snippet

Product ID (ds 1) ProductName (ds 2)

------------------------ ----------------------

11 A

12 B

13 C

123 D



and here's what I'm getting right now:




Code Snippet

Product ID (ds 1) ProductName (ds 2)

------------------------ ----------------------

11 A

12 A

13 A

123 A



Thanks!