move a new column of one table to another table

[tonytang]

Hi everyone,

I would like to add a "Product Name" column in Transaction table, but the variable is in "Product table". Is there any way to join two table together, then i can get the "Product name" incorporated into transaction table? 

The SQL code is like below, but seem Qlikview didn't recognize SQL coding.

Create table new_transaction as select a.*, c.Product name from transaction a left join order b on a.order ID=b.order ID left join Product c on b.Product Sub-Category=c.Product Sub-Category

Hope anyone can help me to solve the issue.

Thanks

[Lisa_P]

You can load Transaction table first then 

Left join(Transaction)
Load ... from Order..;

Left join(Transaction)
Load ... from Product ..;

The tables are fine as they are and would perform better if not joined.

[tonytang]

but how i can create additional table with all  a.*, c.Product name in qlikview? I am struggling in this point