Join Condition

[#1]

I  have a Scenario , where i need to Write a Query and in that query i give the joins between  the table the problem is when i write the query in Edit script. and reload the query after executing reload script . they dnt give me  table column name .if anyone know help me.

is there is any way i can write this Query in Qlik View.

for example:

LOAD   p_department,

       p_personid,      

       pr_description,

       rl_rfqnum,

       prl_pnum,

       po_pnum,      

       prl.polinenum,    

       po_status;

SQL

Select p_department,

       p_personid,

       pr_description,

       rl_rfqnum,

       prl_pnum,

       po_pnum,      

       prl.polinenum,

       po_status     

  from person p

  left join pr pr

    on pr_requestedby = p_personid

  left join prline prl

    on pr_pnum = prl_pnum

  left join rf r

    on prl_rfqnum = r_rfqnum

  left join rfline rl

    on r_rfqnum = rl_rfqnum

  left join po po

    on prl_pnum = po_pnum

  left join poline pol

    on po_pnum = pol_pnum;

[#2]

hi

simply write this

Test_Tablename:

LOAD   p_department,

       p_personid,      

       pr_description,

       rl_rfqnum,

       prl_pnum,

       po_pnum,      

       prl.polinenum,    

       po_status;

SQL

Select p_department,

       p_personid,

       pr_description,

       rl_rfqnum,

       prl_pnum,

       po_pnum,      

       prl.polinenum,

       po_status     

  from person p

  left join pr pr

    on pr_requestedby = p_personid

  left join prline prl

    on pr_pnum = prl_pnum

  left join rf r

    on prl_rfqnum = r_rfqnum

  left join rfline rl

    on r_rfqnum = rl_rfqnum

  left join po po

    on prl_pnum = po_pnum

  left join poline pol

    on po_pnum = pol_pnum;

[#3]

hi i am do this but not give the table column name after reload the edit script

[#4]

below link may help u ...

http://community.qlik.com/groups/qvscriptor-from-schema-to-script/blog/2011/11/11/understanding-join...