Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Problems with and UPDATE QUERY
How? Can u show me the complete Query? I must need a temporal Table of Articles for save the first SELECT? Please, detail the steps. Thanks. -
Problems with and UPDATE QUERY
The Scheme of Database: Table Fields Articles Art_Codi VARCHAR(10) Key Art_Des VARCHAR(25) Art_Fam VARCHAR(25) Art_Cost_Pts DECIMAL(12,4) Art_Cost_Eur DECIMAL(12,4) Art_Cod_Mod VARCHAR(3) Foreign key references... -
Problems with and UPDATE QUERY
Ok, But there is another way of do this query? Please if u know how, show me. Thanks. -
Problems with and UPDATE QUERY
I try to do this query UPDATE Articles LEFT JOIN Modelos ON Articles.Art_Cod_Mod = Modelos.Mod_Cod SET Articles.Art_Cost_Pts = [Art_Cost_Pts]*(1+(10/100)), Articles.Art_PVP_Pts = [Art_Cost_Pts]*(1+(10/100)) WHERE Articles.Art_Fam Like '*21' AND Articles.Art_Prov Like '*com*'...
