|
|
|
|
||||||
![]() |
|
|
LinkBack | Outils de la discussion |
|
|
#1 |
|
Messages: n/a
Hébergeur: |
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 |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
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 |
|
|
|
#3 |
|
Messages: n/a
Hébergeur: |
jullietta.jung@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. |
|
![]() |
| Outils de la discussion | |
|
|