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.
___
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
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 an