4 Replies Latest reply: Sep 12, 2012 7:32 AM by Miguel Angel Baeyens de Arce RSS

    Anti join - does set analysis force an inner join?

      Hi all,

       

      Attached is a test QVW.

       

      The scenario is this - you want to count those people that appear on Table 1, but NOT on Table 2.  I have tried using set analysis (you will see in Options 1 and 2) but it appears that an inner join is forced.  So I have to use an IF statement (option 3) that works fine.

       

      Can someone confirm that in QV a set analysis always forces an inner join when variables from two (or more) tables are included in the set statement?

       

      Further - if anyone knows a way to do this anti join using Set analysis then I'd love to hear it.

       

      Thanks

       

      Gareth