1--update query example
2 UPDATE table_name
3 SET column1 = value1, column2 = value2, ...
4 WHERE condition;
1UPDATE YourTable
2SET Col1 = OtherTable.Col1,
3 Col2 = OtherTable.Col2
4FROM (
5 SELECT ID, Col1, Col2
6 FROM other_table) AS OtherTable
7WHERE
8 OtherTable.ID = YourTable.ID
1UPDATE STATGLOB1
2SET RESILI = tttt.nnn
3(Select Count(ABONNE.NUMAB) as nnn From (ABONNE
4Inner Join ABONMENT ON ABONMENT.NUMAB = ABONNE.NUMAB)
5Where ABONNE.SECTEUR='01'
6And ABONMENT.ETATCPT=+QuotedStr('40')
7Group By ABONNE.SECTEUR,Left(ABONNE.NUMAB,2),ABONNE.TYPABON,ABONMENT.ETATCPT) as tttt