8 Replies Latest reply: Mar 4, 2013 7:18 AM by Anju Gopinath RSS

    How to differentiate between columns used at different instances?

      Hi friends,

       

      I have a student.qvd file. I have to display 2 reports. They are:

       

      1) Student with id>150

      2) Students whose address is not equal to India

       

      I have written the following code:

       

      report1:

      load   student.name,

                student.address,

                student.id

      FROM

      [C:\Documents and Settings\QV_QVD\student.qvd]

      (qvd) where student.id>150;

       

      report2:

      load   student.name,

                student.address,

                student.id

      FROM

      [C:\Documents and Settings\QV_QVD\student.qvd]

      (qvd) where student.address<>'India';

       

      Now, how i have to differentiate between student names between 2 reports?

       

      Any help is greatly appreciated?