Message de rapport:
 

Re: Erreur requête

Sujet: Re: Erreur requête
par mbsl sur 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é.
Connexion
Menu
Chercher WDForge
Chercher Web
Partenaires
Visualiser tous les Partenaires...
WinDev, WebDev, WinDev Mobile et HyperFile sont des marques déposées par PCSoft. |  Voter |  Legal |  Contact |   XOOPS 2.0.13.2