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 other DBMS) it's no problem - the syntax is;
UPDATE t SET t.debit = trans_debit/a.acc_vat FROM trans t,account a WHERE a.acc_id=t.acc_id --ERROR : near ".": syntax error Why do I get this error? Does SQLite not support joined update statements? Thanks -- View this message in context: http://www.nabble.com/UPDATE-with-JOIN-fails-tp25458099p25458099.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
