c.panel <[EMAIL PROTECTED]> wrote: > Good ! I've not seen like this ! > but why "where t2.DATE <= mytable.DATE" instead of where "t2.DATE < > mytable.DATE"
In each row, do you want balance before that row's credit/debit has taken place, or after? <= does the latter, < would do the former. > because what about if ACCOUNT soon exists with no null value and you > want to update? My statement never uses any previous value of ACCOUNT field, null or otherwise. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users