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

Reply via email to