FROM SQL TO SCRIPT .... very difficult matter:

[#1]

I need to convert this sql query in a load script:

SELECT

CGANA00F.CONTCA AS C_DESTINATARIO_TEMP,

CGANA03F.ITSTAD AS C_PUNTO_VENDITA_TEMP

FROM CGANA00F

LEFT OUTER JOIN CGANA03F ON

CGANA00F.CDDTCA = CGANA03F.CDDTAD AND

CGANA00F.CONTCA = CGANA03F.CONTAD

WHERE

CGANA03F.ITSTAD <> ' '

here my try:

TAB_1:

LOAD CONTCA AS C_DESTINATARIO_TEMP,

  CDDTCA AS key_J ;

//FROM [..\QVD_EME\CGANA00F.QVD] (qvd);

SELECT * FROM CGANA00F;

LEFT JOIN LOAD

CONTAD AS C_DESTINATARIO_TEMP,

ITSTAD AS C_PUNTO_VENDITA_TEMP,

CDDTAD AS key_J ;

SELECT * FROM CGANA03F

// FROM [..\QVD_EME\CGANA03F.QVD]   (qvd)

WHERE ITSTAD <> ' ' ;

DROP FIELD key_J;

but it doesn't work ...

Can you help me?

[kaushiknsolanki]

HI,

     My pleasure.

Regards,

Kaushik Solanki