var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query Help Please...
I am trying to update some values in a table based on a translation table that I have built. I have tried two queries, one whose syntax will not work, and one with undesirable effects.
SET DOCO = PRODDTA.TBL_LEASECOPY.NEWDOCO
WHERE DEVDTA.LN_LEASERECORD.DOCO = PRODDTA.TBL_LEASECOPY.OLDDOCO;
This is exactly what I would like the query to do...it is pretty self expanatory...however PRODDTA.TBL_LEASECOPY.NEWDOCO errors out as an undefined column.
SET DOCO = (SELECT NEWDOCO FROM PRODDTA.TBL_LEASECOPY WHERE PRODDTA.TBL_LEASECOPY.OLDDOCO = DEVDTA.LN_LEASERECORD.DOCO);
This runs however where the select by itself only selects matching records, in the update query, the 226 matching records are correctly updated will 8900+ records are changed to null.
Can anyone tell me what I need to do differently?
Thanks in advance.
WHERE DEVDTA.LN_LEASERECORD.DOCO IN (SELECT OLDDOCO FROM PRODDTA.TBL_LEASECOPY)
That was simple...I feel rather silly...