Report Builder

[daveparrish]

Hi All
I am using report builder to create a report with data from two tables the first is stockmaster and the second is purchdata I have stockmater as the primary and purchdata as the second with the SQL Syntax stockmaster.stockid=purchdata.stockid the problem is it only shows the stockid items from the purchdata, I would like to be able to show all stockid items from stockmaster and add the effectivefrom data as a column.
As always thanks for all the great work.

[TimSchofield]

I think the problem is that the report writer only allows for INNER JOINS whilst you need a LEFT JOIN here.

Tim