Fill Table from multiple data sets in Microsoft report viewer

Question

I have data base with 2 tables "Orders" & "Materials" . In Report data I have created data set named "Orders" which carry columns "Material ID" , "Description" , "Quantity" . I have added table to my report and linked it with orders data set . I want to replace Material ID by it's value from Material Table , I want to write some thing like query to run dynamically in the table . Please advice. thanks

Answer 1

It looks like you need an Inner Join.

SELECT o.Description, o.Quantity, m.Material
FROM Orders o
INNER JOIN Materials m
ON o.MaterialID = m.MaterialID