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

    Right join?



      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.




      right Join (Active)

      LOAD Personnr,









      How do I do it?