Help with joins (or possibly something else!)

[JD*]

I'm trying to figure out if I can structure a query so I can replace one column of data, while leaving the rest alone.

 

My query looks like this:

 

SELECT * FROM database.survey WHERE building = '4'

 

And the result looks like

ID

Building

Teacher

question_1

question_2

...

10001015423613...

 

So what I'm looking to replace is the "teacher" column, which right now only contains an ID. I have a staff table that has their name, so I'm wondering if I can replace their ID with their name, but still keep my query with the "SELECT *", as it's a pain to have to add to the select statement every time someone decides to add another question (and most of these questions have sub questions).

 

I know I can do this easily in PHP with a loop, but I want to push as much processing on the server as possible.

 

 

[rhodesa]

it would be something like this:

 

SELECT q.*,s.name FROM questions q LEFT JOIN staff s ON q.Teacher = s.StaffId WHERE q.building = '4'