Re: [sqlite] Change UPDATE with JOIN sintax

I works like a charm! Thanks for the answer and for the explanation -- View this message in context: http://sqlite.1065341.n5.nabble.com/Change-UPDATE-with-JOIN-sintax-tp79105p79153.html Sent from the SQLite mailing list archive at Nabble.com. ___

Re: [sqlite] Change UPDATE with JOIN sintax

dylan666 wrote: > update Table1 > set Visibility=1 > where ConsumerID in (select * from > Table1 join Table2 > on Table1.ConsumerID = Table2.id > where Table1.visibility = 0 and Table2.visibility = 1) > > Unfortunately I get this error: > only a single result allowed for a SELECT that is part of

[sqlite] Change UPDATE with JOIN sintax

Hi, I'm new with SQLite and I't trying to use an update query with a join. The original query is this: I tyied to chenge it in this way: Unfortunately I get this error: only a single result allowed for a SELECT that is part of an expression What is wrong? Thanks in advance -- View this