Discussion :

[throusseuax]

Bonjour,

J'ai la requete SQL suivante :
SELECT B.FIELDNAME , '|', B.LABEL_ID ,'|', REF.LONGNAME , '|', REF.SHORTNAME,'|', B.LONGNAME ,'|',
B.SHORTNAME, '|',GRLANG.LONGNAME , '|', GRLANG.SHORTNAME,'|', FRALANG.LONGNAME , '|', FRALANG.SHORTNAME ,'&%'
FROM PSDBFLDLABL B left outer join $BASE_REFERENCE.PSDBFLDLABL REF on
( REF.LABEL_ID = B.LABEL_ID and B.FIELDNAME = REF.FIELDNAME)
left outer join PSDBFLDLABLLANG GRLANG on
( GRLANG.LABEL_ID = B.LABEL_ID
and B.FIELDNAME = GRLANG.FIELDNAME and GRLANG.LANGUAGE_CD = 'ITA')
left outer join PSDBFLDLABLLANG FRALANG on
( FRALANG.LABEL_ID = B.LABEL_ID
and B.FIELDNAME = FRALANG.FIELDNAME and FRALANG.LANGUAGE_CD = 'FRA')
left outer join PSDBFLDLABLLANG PORLANG on
( PORLANG.LABEL_ID = B.LABEL_ID
and B.FIELDNAME = PORLANG.FIELDNAME and PORLANG.LANGUAGE_CD = 'POR')
WHERE
( COALESCE(B.LONGNAME,'NULL') <> COALESCE(REF.LONGNAME,'NULL') or
COALESCE(B.SHORTNAME,'NULL') <> COALESCE(REF.SHORTNAME,'NULL')
or (COALESCE(FRALANG.LONGNAME,'NULL') <>
( select COALESCE(GRPLN.LONGNAME,'NULL') from APT10ITF.PSDBFLDLABL GRP
left outer join APT10ITF.PSDBFLDLABLLANG GRPLN on
GRPLN.LABEL_ID = GRP.LABEL_ID and GRP.FIELDNAME = GRPLN.FIELDNAME
and GRPLN.LANGUAGE_CD = 'FRA'
where GRP.LABEL_ID = REF.LABEL_ID and REF.FIELDNAME = GRP.FIELDNAME ))
or (COALESCE(PORLANG.LONGNAME,'NULL') <>
( select COALESCE(GRPLN.LONGNAME,'NULL') from APT10ITF.PSDBFLDLABL GRP
left outer join APT10ITF.PSDBFLDLABLLANG GRPLN on
GRPLN.LABEL_ID = GRP.LABEL_ID and GRP.FIELDNAME = GRPLN.FIELDNAME
and GRPLN.LANGUAGE_CD = 'ITA'
where GRP.LABEL_ID = REF.LABEL_ID and REF.FIELDNAME = GRP.FIELDNAME ))
or (COALESCE(FRALANG.SHORTNAME,'NULL') <>
( select COALESCE(GRPLN.SHORTNAME,'NULL') from APT10ITF.PSDBFLDLABL GRP
left outer join APT10ITF.PSDBFLDLABLLANG GRPLN on
GRPLN.LABEL_ID = GRP.LABEL_ID and GRP.FIELDNAME = GRPLN.FIELDNAME
and GRPLN.LANGUAGE_CD = 'FRA'
where GRP.LABEL_ID = REF.LABEL_ID and REF.FIELDNAME = GRP.FIELDNAME ))
or (COALESCE(PORLANG.SHORTNAME,'NULL') <>
( select COALESCE(GRPLN.SHORTNAME,'NULL') from APT10ITF.PSDBFLDLABL GRP
left outer join APT10ITF.PSDBFLDLABLLANG GRPLN on
GRPLN.LABEL_ID = GRP.LABEL_ID and GRP.FIELDNAME = GRPLN.FIELDNAME
and GRPLN.LANGUAGE_CD = 'ITA'
where GRP.LABEL_ID = REF.LABEL_ID and REF.FIELDNAME = GRP.FIELDNAME ))
)
order by B.FIELDNAME , B.LABEL_ID ;


je chereche a rajouter un critere sur une autre table permettant de faire une limitation des resultats obtenus...
comment puis je faire ?
mes nombreux essais se sont terminés en echecs !!

Par avance merci de votre aide !

[Xo]

Bonjour, et bienvenue sur ce forum,

Merci de tenir compte des CONSEILS... à lire AVANT de POSTER

Pour limiter le nombre de résultats obtenus par une requête, cela dépend de votrre SGBD (LIMIT, condition sur RowNum, etc.)