I just wanted to show the possibility of trying your problem using
1. Update using another table
2. Use of subselects
I forgot to add parantheses around the two subselect statements. The
following should be okey.
update journal set gl_update_flag='Y' where gl_update_flag = 'H' and
posting_da
First, thank you very much for trying but you were a bit off the mark but
close. Second, posting_date being of type char(4) is quite legal and
irrelevant for this exercise but for argument sake lets say char(15) but
apart from all that...
Your sql statement was close but it only update 4 out of
First, posting_date in journal can _NOT_ be of type char(4)! I guess it is
a "date".
Try
update journal set gl_update_flag='Y' from distrib where
journal.gl_update_flag = 'H' and journal.posting_date <= '2001-03-31' and
(journal.objectid = distrib.distrib_objectid or journal.objectid =
distrib.
