"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,
> VariablesPointages.HCalc = 1 ;"
UPDATE VariablesPointages
SET HCalc = 1, CodSoc =
(SELECT CodSoc FROM Sociétés s
WHERE VariablesPointages.Mois = s.Mois)
WHERE Mois IN (SELECT Mois FROM Sociétés);
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
