Update table2 set colname = whatever where exists (select keycol from Table1 where keycol = Table2.keycol)
Dennis McGrath ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lin MacDonald Sent: Monday, October 06, 2008 11:07 AM To: RBASE-L Mailing List Subject: [RBASE-L] - changing values using 'Declare Cursor'? I have 2 tables. They share a key. I need to change the value of a column in Table2 depending if a row with that key exists in Table1. I was thinking to use Declare Cursor, with a Fetch in a While loop, but in the back of my brain I seem to remember reading that that was no longer the best way to do it?? Maybe just my imagination but I thought I would ask, just in case a better method existed, Lin
