SELECT tbc.`ID`, tbc.`Job Title`, ct.contact_id,
ct.contact_type_name, jt.jt_id, jt.jt_name
FROM tblContacts tbc
INNER JOIN `contact_types_sp`ct ON ct.contact_id = tbc.`ID`
INNER JOIN `Job_Titles_tbl` jt ON jt.jt_id = ct.contact_type_name


SELECT tbc.`ID`, tbc.`Job Title`, ct.contact_id,
ct.contact_type_name, jt.jt_id, jt.jt_name
FROM tblContacts tbc
LEFT JOIN `contact_types_sp`ct ON ct.contact_id = tbc.`ID`
LEFT JOIN `Job_Titles_tbl` jt ON jt.jt_id = ct.contact_type_name


SELECT tbc.`ID`, tbc.`Job Title`, ct.contact_id, ct.building_id, bldgs.building_name,
ct.contact_type_name, jt.jt_id, jt.jt_name
FROM tblContacts tbc
LEFT JOIN `contact_types_sp`ct ON ct.contact_id = tbc.`ID`
INNER JOIN buildings bldgs ON bldgs.id = ct.building_id
LEFT JOIN `Job_Titles_tbl` jt ON jt.jt_id = ct.contact_type_name
WHERE tbc.`ID` = 51

Need to change so all jt_names will be in the dropdown, but only the one connected to this user will be selected.