Sam Carleton <[email protected]> wrote: > It is very clear to me that my expectations are wrong, please enlighten > me... > > Here is the query: > > update INVOICE > set SUB_TOTAL = (select sum(PRICE * QTY) from INVOICE_ITEM ii where > ii.INVOICE_ID = *INVOICE_ID*),
where ii.INVOICE_ID = INVOICE.INVOICE_ID -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
