title: Want to use IF THEN
body: <p>I need to ID/tag all contact records of our active clients, even if only <strong>one</strong> of the client's contact records is tagged as <code>ACTIVE</code>.</p>
  
  <p>Specifically, I want to pull all contact records from all companies in my GoldMine database in which <strong>any one</strong> of the company's contact records has the company's account status tagged as <code>ACTIVE CLIENT</code>. Then I plan to take the SQL output, create a group, taking all the contact records from this list and replace the company's account status field from <code>blank or null</code> to <code>ACTIVE CLIENT</code>.</p>