i have a problem with a 'inner join' from two table,
my script looks like this:
LOAD * ;
SQL SELECT *
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);
I would suggest to load both tables one-by-one into Qlik. On the 2nd table you call for an INNER JOIN.
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.
Do the key fields have (exactly) the same name? Keeping Case Sensitivity in mind.
Is this an alerady existing sql-query which worked within the database or a new one? What are the problems?
Is the SQL query working in the Database?
Retrieving data ...