inner joins using sql cursor

[vikasmahajan]

Dear  all

I have following master in  views sql

PRODUCT MASTER  VIEW

----------------------------

product code

product name

category

brand

specialilty

PRODUCT BATCH MASTER

----------------------------------------

product code

mfg date

exp date

batch no

I want to join this two masters while loading data in qlikview in my script can any

one tell me the way how we can load and combine this masters while loading time only.

Thanks & Regards

Vikas Mahajan

[jagan]

Hi,

You can directly join the views and load the resultant table into qlikview.

TableName:

SQL SELECT

     *

FROM View1

INNER JOIN View2

ON View1.Key = View2.Key;

Hope this helps you.

Regards,

Jagan.

[vikasmahajan]

Can give me syntax with data loading scripts

Thanks for help

Regards

Vikas