Re: SQL 400 Update with SubSelect

Shannon,

> update HEADER set HEADER.FIELD1 = ' ' where (select * from header,detali
> where HEADER.FIELD2 =  'A' AND
> HEADER.FIELD3 = 'B' AND HEADER.FIELD4 = 'C' AND DETAIL.FIELD1 > 30)

try

update header h
    set h.field1 = ' ' 
 where h.headerkey = (
           select a.headerkey 
           from header a
            join detail b
              on a.headerkey = b.detailkey 
         where a.field2 = 'A'
            and a.field3 = 'B'
            and a.field4 = 'C' 
            and b.field1 > 30
                   )

hth,

rick