How to identfy whether multiple records available in a table?

[user3715001]

i have a table Subscription,occupant,Address.I need to find out wether multiple address and occupant availble for a subscription.

in quick index for subscription i have the following details

flags index name st area cnt field name
addressoccupant 999 2 + Addressid
+ Occupantid

pu subscription 999 1 + subscriptionid


Address table - addressid is primary unique Occupant table -Occupantid is primnary unique

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.
​

Please let me know how to find this.

Continue reading...