叶艳红 <[email protected]> wrote: > update dzhhq set mnote= > case when (select dzhhq.*,b.bs from dzhhq inner join (select bs,stkcode > from buysell) b on dzhhq.stkcode=b.stkcode) then 'sell'||mnote > else mnote > end
I'm not quite sure I understand what you are trying to achieve. Perhaps something like this: update dzhhq set mnote= 'sell' || mnote where stkcode in (select stkcode from buysell); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
