Link Table..Code

[#1]

Whats wrong in this code.. I am getting a error at JOIN (LINK_tabelle) LOAD DISTINCT

can anyone help me??

DL_AUFTRAGGEBER:
LOAD autonumber( DL_ID & FIRMA_ID & FIRMA_FB_KUERZEL & LEITER_NAME) as DL_KEY_AUFTRAG,
 DL_ID,
 FIRMA_ID,
 FIRMA_FB_KUERZEL,
 LEITER_NAME;
SQL SELECT *
FROM DVG.DL_AUFTRAGGEBER;


LINK_tabelle:
Load distinct DL_KEY_AUFTRAG,
 DL_ID,
 FIRMA_ID,
 FIRMA_FB_KUERZEL,
 LEITER_NAME
 resident DL_AUFTRAGGEBER;

 Drop Fields DL_ID, FIRMA_ID, FIRMA_FB_KUERZEL, LEITER_NAME FROM DL_AUFTRAGGEBER;

DL_AUFTRAGNEHMER:
LOAD autonumber( DL_ID & FIRMA_ID & FIRMA_FB_KUERZEL & LEITER_NAME) as DL_KEY_AUFTRAG,
 DL_ID,
 FIRMA_ID,
 FIRMA_FB_KUERZEL,
 LEITER_NAME,
 VERANTWORTLICH;
SQL SELECT *
FROM DVG.DL_AUFTRAGNEHMER;

JOIN (LINK_tabelle) LOAD DISTINCT
DL_KEYAUFTRAG,
DL_ID,
FIRMA_ID,
FIRMA_FB_KUERZEL,
LEITERNAME
resident DL_AUFTRAGNEHMER;

DROP FIELDS DL_ID, FIRMA_ID, FIRMA_FB_KUERZEL, LEITERNAME FROM DL_AUFTRAGNEHMER;

[Anonymous · Accepted solution]

LEITERNAME should be LEITER_NAME in your last resident load.

[#3]

Thanks Jsomsen..I just copied it wrong..That is corrected but it does not help..Same Problem..

[#4]

I think that QV, automaticly concatenate first two of your tables..

[#5]

Thanks Vrbcic..I corrected that one also by adding noconcatenate but still it has a problem..It says keyfield DL_KEY_AUFTRAG not found

LINK_tabelle:
noconcatenate
Load distinct DL_KEY_AUFTRAG,
 DL_ID,
 FIRMA_ID,
 FIRMA_FB_KUERZEL,
 LEITER_NAME
 resident DL_AUFTRAGGEBER;

[#6]

Done it. Sometimes small ", "or "_ "does irritate u..there was missing '_'

Thanks guys...