|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
22/04/2006, 17h52
|
#1 |
Messages: n/a
Hébergeur: |
How to: retreive school name using school id
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 |
|
|
22/04/2006, 18h25
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: How to: retreive school name using school id
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 |
|
|
|
23/04/2006, 01h57
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: How to: retreive school name using school id
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 | |
|
|
