Viewing 2 posts - 1 through 2 (of 2 total)
Thank you all. GlJJR I was able to use the code that you posted and it worked wonderfully. It brought back fewer rows which helped me to identify...
October 30, 2003 at 8:01 am
#480317
I am updating a field on one table based on the value of a field from a different table.
UPDATE TABLE1
SET TABLE1.media1_id =
(SELECT c.agreement_id
...
October 27, 2003 at 12:40 pm
#479752