On Sat, May 16, 2009 at 5:35 PM, velkropie <velkro...@gmail.com> wrote: > > Hello, > > I'm trying to update two tables with one statement but, i'm not getting > something right. can someone here help me , or guide me to the right place > to get help? > > Thanks > > "UPDATE funrecipes, ingredients SET funrecipes.recipetitle, > funrecipes.copyright, funrecipes.directions, ingredients.ingredient_name > WHERE ingredients.pk = funrecipes.pk" > > this is returning a database error, any ideas?
yea... it is wrong. You can update one or more columns in one table in one statement, not more than one tables in one statement. -- Puneet Kishor http://www.punkish.org/ Carbon Model http://carbonmodel.org/ Charter Member, Open Source Geospatial Foundation http://www.osgeo.org/ Science Commons Fellow, Geospatial Data http://sciencecommons.org Nelson Institute, UW-Madison http://www.nelson.wisc.edu/ ----------------------------------------------------------------------- collaborate, communicate, compete ======================================================================= Sent from Karlstad, Sweden _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
