[sqlite] Updating two tables rows in one sql statement

2009-05-16 Thread velkropie
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,

Re: [sqlite] Updating two tables rows in one sql statement

2009-05-16 Thread P Kishor
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

Re: [sqlite] Updating two tables rows in one sql statement

2009-05-16 Thread John Machin
On 17/05/2009 1:35 AM, velkropie 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,

Re: [sqlite] Updating two tables rows in one sql statement

2009-05-16 Thread velkropie
John Machin wrote: On 17/05/2009 1:35 AM, velkropie 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

Re: [sqlite] Updating two tables rows in one sql statement

2009-05-16 Thread John Machin
On 17/05/2009 10:34 AM, velkropie wrote: John Machin wrote: On 17/05/2009 1:35 AM, velkropie 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