S
Security
I would like to know the meaning of this query
INSERT INTO [TABLE1] ( codcli, [flag griffe], qte, [qte griffe] )
SELECT [TABLE1].codcli, [TABLE1].[flag griffe], Sum([TABLE1].qte) AS
SommeDeqte, Sum([qte])+0 AS Expr1
FROM [TABLE1] GROUP BY [TABLE1].codcli, [TABLE1].[flag griffe]
I don't understand the meaning of the syntax : INSERT INTO ... SELECT ...
FROM ?
Second question : does an 'IF' be as part of an SQL request : If ... Then
....
thank you
INSERT INTO [TABLE1] ( codcli, [flag griffe], qte, [qte griffe] )
SELECT [TABLE1].codcli, [TABLE1].[flag griffe], Sum([TABLE1].qte) AS
SommeDeqte, Sum([qte])+0 AS Expr1
FROM [TABLE1] GROUP BY [TABLE1].codcli, [TABLE1].[flag griffe]
I don't understand the meaning of the syntax : INSERT INTO ... SELECT ...
FROM ?
Second question : does an 'IF' be as part of an SQL request : If ... Then
....
thank you