Retrieve Data from many-to-many table in SQL Server

Question

I'm new to SQL Server. I don't know how I can retrieve data from a many-to-many table.

My tables looks like:

Hospitals:

Treatments:

hospitals_treatments:

How can I view my data like on table hospital_treatment but instead of id I want name from respective tables. How can I do that?

Answer 1

Try this

SELECT
b.name, c.name
FROM
    Hospital_treatment a
JOIN Hospitals b
    ON a.hospitalshospital_id = b.id
JOIN Treatments c
    ON a.treatmentstreament_id = c.Id