Trying to Left Join

[RichardLee]

I'm trying to do a Left Join on the following

LOAD cbCreation,
CT_Intitule,
CT_Num,
CT_Pays;

SELECT cbCreation,
"CT_Intitule",
"CT_Num",
"CT_Pays"
FROM "SAGE_SAGECOMPTA_BASE".dbo."vF_COMPTET" WHERE CT_Type=1;

FrenchInvoices:

LOAD
EC_CTNUM,
EC_ECLETTRE,
EC_ECMONTANT_C,
EC_ECMONTANT_D,
EC_ECREFERENCE;

SELECT "EC_CTNUM",
"EC_ECLETTRE",
"EC_ECMONTANT_C",
"EC_ECMONTANT_D",
"EC_ECREFERENCE"
FROM "SAGE_SAGECOMPTA_BASE".dbo."vF_ECRITUREC";

FrenchData:
Select 'all' [FrenchCustomers];

Left Join Select 'all'
FROM [FrenchInvoices] Where [CT_Num]=[EC_CTNUM];

Could somebody help?

[mohitp · Accepted solution]

Hi,

Please try the below code:

Data:
LOAD cbCreation,
CT_Intitule,
CT_Num,
CT_Pays;

SELECT cbCreation,
"CT_Intitule",
"CT_Num",
"CT_Pays"
FROM "SAGE_SAGECOMPTA_BASE".dbo."vF_COMPTET" WHERE CT_Type=1;

left join (Data)
LOAD
EC_CTNUM as CT_Num,
EC_ECLETTRE,
EC_ECMONTANT_C,
EC_ECMONTANT_D,
EC_ECREFERENCE;

SELECT "EC_CTNUM",
"EC_ECLETTRE",
"EC_ECMONTANT_C",
"EC_ECMONTANT_D",
"EC_ECREFERENCE"
FROM "SAGE_SAGECOMPTA_BASE".dbo."vF_ECRITUREC";