First of all, I can't find a suitable name for the question, if anyone can find a better one, I'd be very grateful if they edited it. I am new to SQL and I have the following question: I have two tables as follows

Member -> Name, UID (primary key), SupervisorUID. WorkPlace -> WP_UID (primary key), Name, SupervisorUID.

I need to create a query that returns the names of members who work in WorkPlace 'X' and the names of their superiors.

I tried using inner joins but I couldn't achieve the results I wanted. The main question is, how can I select by WorkPlace name and get the member name and superior name.

The superior is also a member, so WorkPlace.SupervisorUID should match Member.UID

SELECT Member.Name, Y
INNER JOIN WorkPlace on WorkPlace.SupervisorUID = Member.UID
WHERE WorkPlace.Name = 'France'

I need to find what to put on Y.

I need to find how to find the uid that matches that supervisor's uid and get the name by getting the uid from the workplace and then going into the members table.

Member
Jeremy 123 421
Jack 421 421

WorkPlace
1 France 421

I want to return the following form,

Jeremy Jack