Question

update a field from a file with a field from a selection from two files

Update, SELECT statement, SQL

Hi!

When I try this:
update fileD d set d.value = (select c.value from (select b.key, b.value from fileB b where b.key not in (select a.key from fileA a)) c where d.key = c.key)
I get the message "Null values not allowed in column or variable VALUE."

on the other hand, when I do this selection:

(select c.value from (select b.key, b.value from fileB b where b.key not in (select a.key from fileA a)) c)

I get 46 records (value).

Any hint...?

Thanks in advance.
Eduardo

Hi again!

I already have the answer (I'll just use the real files and fields). Goes like this:

update FCONTF A set VALCOM = (select sum(CMCOMI) from FMCM000FEN
where CMNDOS = A.CONCON and CMNDOS not in (select CMNDOS from FMCM000F) group by CMNDOS)
where exists (select distinct CMNDOS from FMCM000FEN
where CMNDOS = A.CONCON and CMNDOS not in (select CMNDOS from FMCM000F))