Implement sql in script editor

[#1]

Hi ,

I have below SQL which I want to implement in Qlikview, I understand this can be done by script editor, please suggest options to do this

Select col1, col2

from table1, table2

where table1.col1=table2.col2

[Gysbert_Wassenaar]

See this video tutorial

[#3 · Accepted solution]

table1:

LOAD col1 AS KEY ;

SQL Select col1 FROM SOURCE

//table2

INEER JOIN(table1)

LOAD col2 AS KEY ;

SQL Select col2 FROM SOURCE