3 Replies Latest reply: Feb 21, 2011 10:20 AM by Muncho Ts RSS

    Where exists?

      Hello all

      I'm totally new in QV.

      I got 2 table. like this

      tabel1:

      Country , Zone....

      AE, 1

      AT, 2

      AZ, 3

      BA, 4

      BZ, 5

      CZ, 6

      table2:

      Country, Zone...

      AE, 1

      AZ, 3

      Ba,4

      i want to show only existing countries. I dont want to join them. Is there any way to do this.

      Well i tried to use where exists function but no luck. Also i tried to search google and qv help but i didnt got any clear answers.

      Can someone show me how to do this and describe it liiitle bit?

      I know i got some synthetic keys and that's will be my next question ^^