Re: [sqlite] SQL "UPDATE" question

2008-10-15 Thread Igor Tandetnik
"jm cuaz" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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, > Variab

[sqlite] SQL "UPDATE" question

2008-10-15 Thread jm cuaz
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 = S