Join

[#1]

Hy,

i have a problem with a 'inner join' from two table,

my script looks like this:

LOAD * ;

SQL SELECT *

FROM PANTH01.THIP.ORD_SRV

inner join (ORD_SVR_ATV) SELECT * FROM PANTH01.THIP.ORD_SRV_ATV

ON (ORD_SRV.ID_AZIENDA = ORD_SRV_ATV.ID_AZIENDA)

AND (ORD_SRV.N_AZIENDA = ORD_SRV_ATV.N_AZIENDA);

[oknotsen]

I would suggest to load both tables one-by-one into Qlik. On the 2nd table you call for an INNER JOIN.

TableOne:

LOAD * ;

SQL SELECT *

FROM PANTH01.THIP.ORD_SRV;

TableTwo:

INNER JOIN(TableOne)

LOAD * ;

SQL SELECT *

FROM PANTH01.THIP.ORD_SRV_ATV;

[marcus_sommer]

Is this an alerady existing sql-query which worked within the database or a new one? What are the problems?

- Marcus

[#4]

thank you,

but I've already tried that and the resulting table is empty.

so I simulated the same command with two conditions in sql and I have a populated table.

[reddy-s]

Hi Giorgio,

Is the SQL query working in the Database?

Thanks,

Sangram.

[oknotsen]

Do the key fields have (exactly) the same name? Keeping Case Sensitivity in mind.

[#7]

yes