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
