hi i.m new user with sqlite and now i have this problem with update function: with mysql run this script:
UPDATE TabAgeFattProdutt INNER JOIN TabTestaFattAG ON TabAgeFattProdutt.NumFattAG = TabTestaFattAG.NumFatt SET TabAgeFattProdutt.Stato ='I', TabTestaFattAG.StatoFatt = 'Chiusa' WHERE TabTestaFattAG.NumFatt = '23/12' but under sqlite not work!!! i think about the problem is the syntax but where??? thanks Alex -- View this message in context: http://sqlite.1065341.n5.nabble.com/Update-with-two-tables-tp9506p66287.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
