How to access data using a SQL query that references multiple tables?

I have a few tables and inserted values into them using SQL plus:

INSERT INTO Location(name, addr, phone) VALUES ('Texas Branch',
'4832 Deercove Drive, Dallas, TX 75208', '214-948-7102');

INSERT INTO Librarian(eid, ID, pay, Loc_name) Values
(2591051, 88564, 30000.00, 'Texas Branch');

INSERT INTO Stored_In(media_id, name) VALUES(8733, 'Texas Branch');

Suppose I write a SQL query like select location = "texas branch", then the output should contain the librarian for the Texas branch and media_id, the name stored_in - in simple words, I should get all the information related to Texas branch)

Can anyone please help write the SQL query ?