normalization in sql

See more:

SQL-Server-2005

SQL-Server

Hello,
I have three table names like inventory, inventory_temp and purchase

 create table inventory(id int,productid int,quantity decimal(18,4), disptchtype int)

   create table inventory_temp(id int,productid int,quantity decimal(18,4), disptchtype int ,loaded_qnty decimal(18,4))

 create table purchase (id int,productid int,loaded_qnty decimal(18,4))

insert into inventory values(1,1,1000,1)
insert into inventory values(2,3,2000,1)
insert into inventory values(1,3,3000,2)
insert into inventory values(2,4,4000,2)

insert into purchase values(1,1,1200)
insert into purchase values(2,3,2300)

insert into inventory_temp(id,productid
quantity,dispatchtype)
select id,productid, quantity,dispatchtype from inventory  
where dispatchtype=1

now i want to show table inventory_temp like

id-----productid-------quantity------dispatchtype-------loaded_qnty
1---------1-------------1000------------1-----------------1200
2---------3-------------2000------------1-----------------2300

but i dont want to use join i want to update my inventory_temp table
how can i do pleas help