3 Replies Latest reply: Nov 22, 2012 10:10 AM by julia.petersson RSS

    Right join?

      Hi,

       

      How do I do if I only want to join the rows in table "All" if they can be found in table "Active"?

       

       

      If I hade a sql query I would join my tables like:

       

      select * from

      All all

      right join Active active on all.email=active.email_adress

      ...

       

       

      I want all the rows in table "Active" to be shown and combined with table "All".

      If the row is only found in "All" it should not be included.

       

       

      In qlikview I try to do it like below, but I still got all rows from "All", dispite if they match or not.

       

       

      //All:

      right Join (Active)

      LOAD Personnr,

           email,

           kategori,

           created_at

      FROM

      ....

      ;

       

       

      How do I do it?

       

      /Julia