4 Replies Latest reply: Aug 4, 2010 4:50 AM by Josetxo Josetxo Amonarriz RSS

    Usage of "exists"

    Josetxo Josetxo Amonarriz


      I am trying to check if the value of a field (CustomerID) in a table A is in any record of other table B, in the field PartnerID.

      I am processing every record in table A. If the value of the CustomerID field can be found in table B, I'll update a field in table A.

      I have tried with exists:

      if(exists(CustomerID, PartnerID), "Yes","No") as CustomerIsPartner,

      but QV cannot find PartnerID.

      Should I go this way or can this be achieved with any other command?

      Many thanks in advance.