Probleme Round migration Sybase -> SQL Server
Bonjour,
Je suis en train de plancher sur une migration de base Sybase vers SQL server et je suis face a un problème:
...
Code:
1 2 3 4 5 6 7 8 9
| SELECT SUM(LFC4.lfac_mttero_ht)*FC2.efac_tauchg
FROM lig_facture_cli LFC4,facture_cli FC2
WHERE LFC1.lfac_codsit = LFC4.lfac_codsit
AND LFC1.lfac_numfaccli = LFC4.lfac_numfaccli
AND LFC1.lfac_numligfaccli = LFC4.lfac_numligfaccli
AND LFC1.lfac_codsitref = LFC4.lfac_codsitref
AND FC1.efac_codsit = FC2.efac_codsit
AND FC1.efac_numfaccli = FC2.efac_numfaccli
AND FC1.efac_codsitref = FC2.efac_codsitref), |
...
J'obtiens le message suivant:
Column 'FC2.efac_tauchg' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
Merci d'avance pour vos suggestions