Steve The update command looks valid. Is it not working?
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, December 12, 2003 3:13 PM Subject: [RBASE-L] - SQL Help > Need a little help with an SQL command. I use the following: > > update VariableValues set v1.Var_Value = 'test' from VariableValues v1, > Variables v2 where (v1.SiteID = '1' and v2.Var_Name = 'Title' and (v1.Var_ID > = v2.Var_ID)) > > I want to update the column Var_Value in table VariableValues, but the only > row values I have are SiteID from VariableValues and Var_Name from > Variables. Var_ID in VariableValues is a Foreign Key from Var_ID in > Variables. > > Any help would be appreciated. > > Thanks > > Steve Fogelson > Internet Commerce Solutions > >
