locked
CRM customization RRS feed

  • Question

  • Hi,

    I have a following query which I need to set into ConditionExpression and FiltersExpression--

     

    SELECT  new_annualrevrange, new_noofftemployees, new_noofcontingent
    FROM     Account
    WHERE   StateCode = 0
    AND       AccountID NOT IN (SELECT AccountID
                 FROM   Account
                 WHERE  new_annualrevrange IS NULL AND new_noofftemployees IS NULL AND new_noofcontingent IS NULL)

    Can any one suggest me how can I achieve this?

    Regards,
    Krunal

     


    Krunal Doshi
    Wednesday, January 27, 2010 11:05 AM

Answers

All replies