Order_detail and Item_detail, its use item_id to link each other.
Now, i want to update data from Item_detail to Order_detail.
Code: Select all
sql = "update Order_detail set Pqty = ( select pqty from Item_detail ) where Pqty = 0 ; "Anyone can help me ?
Thank u