Re: Erreur requête

Posté par mbsl le 19/1/2006 16:24:05

Essayez

SELECT I.ID AS ID, S.HSS_Code AS HSS_Code, I.HasQualityImpact AS HasQualityImpact, I.SEQ AS SEQ, I.System AS System, I.Description AS Description,
I.Platform AS Platform, I.Soft AS Soft, I.InHouseDevelopment AS InHouseDevelopment, I.Location AS Location, C.Designation AS ControllingFunction,
I.QSR AS QSR, I.LinkedToSystem AS LinkedToSystem, I.LinkedToHardwareComponent AS LinkedToHardwareComponent,
I.LinkedToSoftwareComponent AS LinkedToSoftwareComponent, I.LinkedToDatabaseComponent AS LinkedToDatabaseComponent,
I.NotApplicableForDRP AS NotApplicableForDRP, P.ProviderName AS ProviderName, I.HasERESImpact AS HasERESImpact
FROM SYSTEM_CODE S, INITIAL_INVENTORY I, CONTROLLING_FUNCTION C, PROVIDER P
WHERE S.ID = I.SystemCodeID
AND I.ControllingFunctionID = C.ID LEFT
AND .ProviderID = P.ID
ORDER BY S.HSS_Code, I.HasQualityImpact DESC, I.SEQ

Si je ne me suis pas trompé.