How to: retreive school name using school id

[jullietta.jung]

HI,

I have a Questionnaire table that has a column "SchoolId"(int).
I want to return the questionnaire table with the name of the school
rather than the SchoolId (schoolid and schoolName are stored in another
table).

Hope this makes sense.
Thanks
Jules

[jullietta.jung]

Sorry I should add that there are 2 schoolId coloumns in the
questionnaire table.
I school id for the visiting school and another for the home school.

- Jules

[Bill Karwin]

ju************@gmail.com wrote:

HI,

I have a Questionnaire table that has a column "SchoolId"(int).
I want to return the questionnaire table with the name of the school
rather than the SchoolId (schoolid and schoolName are stored in another
table).

Sounds like you need to make a join between the two tables:

SELECT s.schoolName, q.question, q.answer
FROM school AS s JOIN questionnaire AS q USING (SchoolId)

Regards,
Bill K.