Join in QV script

[#1]

Hi,

could anyone translate following sql into qv:

left join table2fieldX on table2fieldA=table1fieldB and table2fieldC = string?

I want to load from QVD's and make the join there.

Kr,

Daniel

[rajeshvaswani77 · Accepted solution]

mytable:

LOAD

*,

fieldA as Link

from table1;

left join (mytable)

LOAD

fieldB as Link,

fieldC

from table2 where fieldC=string;

thanks,

Rajesh Vaswani

[#3]

Thanks a bunch! You're a life saver!

[rajeshvaswani77]

Hi Daniel,

Could you please mark as correct answer or helpful answer.

regards,

Rajesh Vaswani

[#5]

Sorry,

here you go.