Dan, Following is a simple example of Co-Relational Update! UPDATE CurrentTable SET CurrentColumn = LookupColumn + FROM LookupTable, CurrentTable + WHERE CurrentTable.CurrentColumn = LookupTable.LookupColumn For more details on UPDATE command, check out the latest and greatest: http://www.RSyntax.com Have Fun! Very Best Regards, Razzak. At 05:38 PM 5/30/01 -0500, Dan Weissmann wrote: > >I'm trying to update a column in table one with the values in >table 2. Seems simple, but nothing is being updated. What am >I missing? > >UPDATE <table1> SET <column1> = <column1> FROM <table1> T1, ><table2> T2 WHERE T1.Columnx = T2.columnx > >There are values in <table2.column1.> but no values in <table1.column1>. >After the UPDATE is run, there are still no values in <table1.column1> ===================================-============================ Official R:BASE List Server: mailto:[EMAIL PROTECTED] RBTI Events/Training: http://www.rbase2000.com/events R:DCC Members: http://www.rbase2000.com/rdcc ================================================================ R:BASE, Oterro & R:Tango are registered trademarks of RBTI. ==================================-=============================
