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 this command: (select dzhhq.*,b.bs from dzhhq inner join (select bs,stkcode from buysell) b on dzhhq.stkcode=b.stkcode); Could searched the result But how to update
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
