I am trying to make multiple joins between two tables and am at a loss. I've tried a variety of things with this being the latest, but it pulls all records multiple times.

Basically I have a main table of profiles that have several descriptors that are referenced with a SQL ID that is in a DropDown table.

Code:
Table Profile
profiletype (SQL ID)
phoneprovider (SQL ID)

Table DropDowns
ID
...