Update Query Help

[Walshie]

Hi,

Apologies i'm failry new to SQL and am really struggling with this UPDATE query.

I have two Tables "Stock" and "Stock Master"

They both have "ItemNo" fields and also "Quantity" fields.

All I want to do is transfer the "Quantity" from "Stock to "StockMaster " where the "ItemNo" is the same in both tables.

I've tried all variations of UPDATE and INNER JOINS etc but can't seem to figure this out.

Any advise would be greatly appreciated!

Cheers
Chris

 

[MStef]

You don't need a same data in the 2 tables.

 

[Walshie]

Hi,

This is a simlified version of what I require, what i have is a report that is sent to me each week as .CSV. This contains different quantities each week i receive it.

I am using "Stock" as a temp table to which i import the CSV, then using VBA / SQL I insert a new column in "StockMaster" named "Quantity Week XX" for example.

All of the above Is working fine.

The final stage is that i need to pull in the values from "Stock" (the Temp Table) to "StockMaster". Basically I am creating a history of Stock levels from items.

The format I am doing this works fine for what I need therefore I don't want to move away from this structure.

Hope this makes things slightly clearer.

Thanks
Chris