title: How to identfy whether multiple records available in a table?
body: <blockquote>
    <p>i have a table Subscription,occupant,Address.I need to find out wether multiple address and occupant availble for a subscription.</p>
    
    <p>in quick index for subscription i have the following details</p>
  
  <pre><code>   flags   index name         st area  cnt field name
              addressoccupant     999      2  + Addressid
                                          + Occupantid
  
      pu    subscription       999      1 + subscriptionid
  </code></pre>
    
    <p>Address table - addressid is primary unique
    Occupant table -Occupantid is primnary unique</p>
    
    <p>when i query i can't find any multiple address and occupant for a subscription but i need to   make sure wether it can have multiple address and occupant for a subscritpion.</p>
  </blockquote>
  
  <p>Please let me know how to find this.</p>