Inner join issue

[#1]

Hi All,

I have to get A1, A2, A3, A4, C3 into my QLikview table and it is giving error saying that C3 not existed.

Tab1:          

A1    A2    A3    A4

Tab2:          

B1    B2    B3  

Tab3:          

C1    B2    C3  

LOAD A1,A2, A3, A4, C3;

sql SELECT * FROM

SQL SELECT * FROM tab1 a

left join Tab2 b on a.A1 = b.B2

left join Tab3 c on b.B1 = c.C1;

[maxgro]

remove bold

LOAD A1,A2, A3, A4, C3;

//sql SELECT * FROM

SQL SELECT * FROM tab1 a

left join Tab2 b on a.A1 = b.B2

left join Tab3 c on b.B1 = c.C1;

[sundarakumar]

i dont think the error is with qlikview load. try to remove the precedent load and check if C3 is available form the SQL pull. if yes check on what name it is getting loaded into qlikview. if no ur SQL query to pull data should be revisited.

and yes u will have to comment the bold line specified by massimo.

-Sundar