isql detail table update?

Table schemas: -------------- create table "root".atkliquh # HEADER Table ( *tk_num integer not null, c_num char(6), job_num integer, route_num integer, tk_date date, emp_num smallint, truck_num char(5), trailor_num char(5), inv_num char(10) ); create table "root".atkliqud # DETAIL Table ( *tk_num integer not null, *item_num smallint, unit_type char(20), unit_desc char(15), unit_price decimal(8,4), quantity decimal(8,2), total_price money(8,3) ); Question -------- In the above header --> detail tables I need to do an isql update on the detail table using a subquery and don't know how to do it. Here's the algorithm of what I would like to do: update atkliqud set unit_type = "Sludge" where atkliquh.job_num = 100 and atkluquh.tk_num = atkliqud.tk_num Any help would be deeply appreciated. -- Unix at Home perk machine Joseph A. Miele jam@perk.jpr.com Dir MIS Spectraserv, Inc. 76207.1365@compuserve.com