2 tables same field name

[JACKNIEKERK]

2 tables with same keyname ARTNR

LOAD ARTNR,
MENGEKG,
PREISLV,
PREISGV,
PREISEKES,
PREISLVES,
VORGDATUM;
SQL SELECT * FROM umsatzPOS where VORGDATUM = '12-5-2019';

LOAD ARTNR,
ARTID,
ARTBEZ,
ARTEINHEIT,
VERGLEICHT,
TEXTID0,
TEXTID1,
TEXTID2,
TEXTID3,
TEXTID4;
SQL SELECT * FROM STAMMARTIKEL;

This generates a $Syn1 table

creating a grafic object will say all expressions deactivated

i need a connection by pickinng ARTNR form STAMMARTIKEL; and show all records in umsatzPOS with that ARTNR

[Kushal_Chawda · Accepted solution]

If I understood correctly, basically you need a join of two table here

Data:
LOAD ARTNR,
ARTID,
ARTBEZ,
ARTEINHEIT,
VERGLEICHT,
TEXTID0,
TEXTID1,
TEXTID2,
TEXTID3,
TEXTID4;
SQL SELECT * FROM STAMMARTIKEL;

left join(Data)
LOAD ARTNR,
MENGEKG,
PREISLV,
PREISGV,
PREISEKES,
PREISLVES,
VORGDATUM;
SQL SELECT * FROM umsatzPOS where VORGDATUM = '12-5-2019';

[JACKNIEKERK]

true, only changed the algoritme order to   upper line due to reading all sales form data

Items:
left join(Data)
LOAD ARTNR,
ARTID,
ARTBEZ,
ARTEINHEIT,
VERGLEICHT,
TEXTID0,
TEXTID1,
TEXTID2,
TEXTID3,
TEXTID4;
SQL SELECT * FROM STAMMARTIKEL;

Data:
LOAD ARTNR,
ARTBEZ as plubez,
MENGEKG,
PREISLV,
PREISGV,
PREISEKES,
PREISLVES,
VORGDATUM;
SQL SELECT * FROM umsatzPOS where VORGDATUM = '12-5-2019';

[JACKNIEKERK]

thanks for help,  regards Jack