Question about load data from two tables with SQL.

[Anonymous]

Hello,

Escuse me, I have a problem. this is not many time I start with QlikView and I have many question.

I need to load rows data of quantity and amount per article but I have this data in two tables with different name and different fields  names.

I load with SQL anfd I user the table item.

So:

ODBC CONNECT TO DATA01;

// First table with rows with quantity and Amount
Table1:
SQL SELECT
    Table1_ItemCode AS Table3_ItemCode,
    Table1_Quantity,
    Table1_Amount
FROM Table1;

// Second table with rows with quantity and Amount
Table2:
SQL SELECT
    Table2_ItemCode AS Table3_ItemCode1,
    Table2_Quantity,
    Table2_Amount
FROM Table2;

// Item Table

Table3:
SQL SELECT
    Table3_ItemCode,
    Table3_ItemCode AS Table3_ItemCode1,
    Table3_ItemDescription,

I must do a temporary table? How?

I dont want use Synth Key also (I have use a alias in Table3 for Table 2 but I dont know if this is the right way).

Thank you very mych!!!

Best regards.

[Anonymous]

Yes, yes, yes!!!

IT WORK NOW!!!

You are great Ruben! :-))))))

Thank you very much!

Now I think it is a bug of QlikView or can be the database (I dont think this if now it work), what do you think?

Anyway thank you very much again!

[rubenmarin1]

You're welcome Giuseppe.

I have no idea of why isn't sorting it right in TempDates, but I'm glad it works now.