U
user3715001
Guest
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...