Query to Joining two tables

[Massoud]

Hi,
I have two tables Inputs ( with the fields : GoodsId, Net , Quantity) and Outputs ( again with the fields : GoodsId, Net , Quantity).
How can I design a query so that in each row I have the following result
GoodsId, SumNetInput, SumQtyInput, SumNetOutput, SumQtyOutput?

I need the sql string to use it in my program.

Thanks in advnace

 

[JamesMcS]

Just create the query in design view and switch to SQL view to copy the code....