Sorry that the spacing is off...let me know if it makes it confusing.

Phones

customer_id phone_number primary
-------------- ----------------- ---------
123 555-5555 Y
123 333-3333
123 444-4444
456 333-3030 Y
888 454-4403
888 234-4432


Customers

customer_id name
-------------- ------
123 bob
456 jon
888 sue

So i would want 555-5555 for bob, 333-3030 for jon, and either one of the numbers for sue (but just one of them).