thank you.

I want only a particular phone for the consumer.

Each consumer can have 0 phone or more than one phone number,i want only primary phone.

similarly address, consumer can have more than one address or 0 address, i want only primary address.

From consumerphone where phoneTypeID=1

From ConsumerAddress where AddressTypeID=1

For ConsumerIdentifier is a table with SSN and medicaid.

So for a particular consumer, ConsumerIdentifier table will have

ID=1 value=xxxx - where id=1 means SSN

ID=2 value=yyyy - where ID=2 means medicaid