Posted on 2005-05-07
I'm a newby and I'm sure I'm screwing this up, but I need help anyway. I'm trying to insert a row into one table from some values from another table.
insert into empty (item_no, description, loc1, loc2,qty_on_hand,qty_on_sales_order,qty_on_purchase_order, closeout) values
(select no, description, location1, location2, qty_on_hand, qty_on_sales_order, qty_on_purch_order, closeout
from item where no = '340666')
What am I doing wrong here? Thanks in advance.