Re: [sqlite] UPDATE with JOIN fails

Amazing!! That worked! Thanks Igor! -- View this message in context: http://www.nabble.com/UPDATE-with-JOIN-fails-tp25458099p25460200.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org h

[sqlite] UPDATE with JOIN fails

I'm trying to update one table based on information in an other. I have two tables, transactions (trans) and accounts (account). I want to update the debit amount in the transaction table (trans) with vat information from the accounts table (account) for a particular account. Normally (ie. in othe