| | |
|
|
|
Re: ASP and database question |
|---|
| message from cmbergin on 22 Jul 2004 |
That's correct.
Now you get to go learn SQL! :)
There are plenty of tutorials; you'll be fine.
But, to get you started, here's basically how you'll get the registration list:
SELECT C.Title, S.Name
FROM Registrations R INNER JOIN Classes C ON R.ClassID=C.ClassID INNER JOIN
Students S ON R.StudentID=S.StudentID
ORDER BY C.Title, S.Name
You can go from there. Only want a single class? Just add WHERE ClassID=X in
front of the ORDER BY clause. Single student's class list? WHERE StudentID=X.
And so on and so forth....
|
|
Archived message: Re: ASP and database question (Macromedia Dreamweaver)
