Igor,
It took me a bit of looking, but I think I understand your query. One question
remains: why did you use the max() function?
Thanks!
RobR
-Original Message-
update adla1 set PFLOPF=(
select case count(*)=1 then max(adl.pflopf) else adla1.pflopf end
from adl where
On 5/16/2014 11:02 AM, Rob Richardson wrote:
It took me a bit of looking, but I think I understand your query. One question
remains: why did you use the max() function?
It is, technically, not legal in SQL to use both an aggregate function
and a direct field access on the same table. Use
On May 16, 2014, at 6:25 PM, Igor Tandetnik i...@tandetnik.org wrote:
So with SQLite, the query without max() would work, and produce expected
results. With another database engine that enforces SQL rules more strictly,
the query without max() would fail with a syntax error. I figured I'd
Igor Tandetnik wrote...
On 5/16/2014 11:02 AM, Rob Richardson wrote:
It took me a bit of looking, but I think I understand your query. One
question remains: why did you use the max() function?
It is, technically, not legal in SQL to use both an aggregate function
... [clip]
matter which,
Note to self: Someday, you want to be like Igor.
in which way LOL.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, 15 May 2014 18:02:43 +0300
Paul de...@ukr.net wrote:
update adla1 set PFLOPF=(SELECT pflopf from adl where
adla1.ref=adl.ref) where select count(adl.ref) from adl=1;
A bit optimized version...
UPDATE adla1
SET pflopf = (SELECT pflopf FROM adl WHERE adl.ref = adla1.ref)
WHERE