title: How can I correct this query in CakePHP 2?
body: <p>I have a query that I'm trying to create in CakePHP 2.5.5.</p>
  
  <p>My database has two tables that are of interest to this question. The first being <code>Members</code>, and the second being <code>MemberStateLicenses</code>. <code>Members</code> is information on that member, and <code>MemberStateLicenses</code> is a table of licenses that member holds in various states.</p>
  
  <p>This paste contains the array being built for the query before it is passed to the <code>find</code> method: <a href="http://pastebin.com/kM18nKpr" rel="nofollow">http://pastebin.com/kM18nKpr</a></p>
  
  <p>I am attempting to query for any member that resides in a state, or is licensed in a state. For example:</p>
  
  <ul>
  <li><code>Select all members who live in Michigan, or are licensed in Ohio</code></li>
  <li><code>Select all members who live in Maryland, or are licensed in Maryland</code></li>
  </ul>
  
  <p>This is the scenario in which this is failing:</p>
  
  <ul>
  <li>John lives in Ohio.</li>
  <li>John does not have any licenses.</li>
  <li>I query for anyone who lives in Ohio OR is licensed in Ohio.</li>
  <li>No results, even though John does live in Ohio.</li>
  <li>I give john a license in California, and repeat the same Ohio/Ohio query. John is returned, as expected.</li>
  </ul>
  
  <p>So this query is failing when the member has no records in MemberStateLicenses.</p>
  
  <p>My question is this:</p>
  
  <ul>
  <li>What is wrong with my query that is excluding any member that has no <code>MemberStateLicenses</code> record?</li>
  </ul>
  
  <p>Thanks!</p>