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