Re: [sqlite] de...@ukr.net

select from (select ... ) must have alias. It should be select from (select ... ) a On Tue, May 20, 2014 at 9:38 AM, YAN HONG YE wrote: > Hi, > Sorry, I use mysql, not in sqlite, in mysql ,I run this command, the > console show this error: do you know why? > Thank you

[sqlite] de...@ukr.net

Hi, Sorry, I use mysql, not in sqlite, in mysql ,I run this command, the console show this error: do you know why? Thank you very much! mysql> UPDATE adlbk20140520a -> SET pflopf = ( -> SELECT pflopf -> FROM adl -> WHERE adl.ref = adlbk20140520a.ref) -> WHERE ( ->