LOAD vs SQL

Sat, 14 Aug 2010 13:37:55 GMT

Comment peut on traduire la requete suivante eb LOAD de Qlikview.

select a.cdos dossier, a.nmat matricule, a.nom, a.pren prenom, a.dtes dateRecrutement, a.dfes dateFinEmploi, f.vall fonction, f1.vall pays, f2.vall grade
from rhpagent a
left join rhfnom f on f.cdos = a.cdos and
f.nume = '1' and f.CACC = a.FONC and
f.ctab = 7
left join rhfnom f1 on f1.cdos = a.cdos and
f1.nume = '1' and f1.CACC = a.NATO and
f1.ctab = 4
left join rhfnom f2 on f2.cdos = a.cdos and
f2.nume = '1' and f2.CACC = a.CAT and
f2.ctab = 8
where a.CDOS = '01' and a.dtes<to_date('01/01/2007');

Votre aide est tres urgente. Merci

LOAD vs SQL

suniljain — Mon, 16 Aug 2010 06:39:32 GMT

Dear Yimen Gael,

I donot understand language axcepting english. pls post your query in english if possible for you.

Regards

sunil

topic LOAD vs SQL in QlikView

LOAD vs SQL

LOAD vs SQL