Join two tables with more than one similar columns

[Qlikuser09]

Table A has col 1 , col 2 and col 3 

Table B has Col 1 , col 2 , col 3 , col 4 and col 5

I want to join Table A and Table B like Col 1,  col 2 , col 3 , col 4 and col 5 (Note Col 1 is the primary key)

[VishalWaghole]

Hi,

Use below script to join two table where you have more than common keys,

from Table B you can delete common fields or rename it as per your requirement.

Thanks,

Vishal Waghole