Hello, In SQLite, it seems it's not possible to associate several tables in an "update" statement.
Is there a workaround to execute this kind of SQL statement inSQLite : "UPDATE VariablesPointages INNER JOIN Sociétés ON Sociétés.Mois = VariablesPointages.Mois SET VariablesPointages.CodSoc = Sociétés.CodSoc, VariablesPointages.HCalc = 1 ;" Many Thanks Jean-Marie _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
