| Subject | Multiple Joins to the same field |
|---|---|
| Author | ra8009 |
| Post date | 2005-11-02T01:01:52Z |
I have a customers table that lists four different phone numbers and
four different types. For example, phone_type_ID1, phone_type_ID2,
etc. All of these need to join to the same PhoneNumberType table. This
sounds easy, but I've been struggling with the syntax. What's the
right way to do this?
four different types. For example, phone_type_ID1, phone_type_ID2,
etc. All of these need to join to the same PhoneNumberType table. This
sounds easy, but I've been struggling with the syntax. What's the
right way to do this?