Getting multiple comments
Posted: Mon Nov 21, 2005 2:04 pm
Here is the outline:
I have a table, which is holding data for student's report cards. Very normalized, so studentid, school_id, etc. Also, the table holds 3 comments, comment1_id, comment2_id, comment3_id. These are numbers, that are linked to a table called grade_comments, with grade_id being the number, and grade_desc being the actual comment.
Teacher's can choose 1, 2, or 3 comments. How do I build the query to extract this information? I am really stumped!
Any help would be excellent.
Doug
I have a table, which is holding data for student's report cards. Very normalized, so studentid, school_id, etc. Also, the table holds 3 comments, comment1_id, comment2_id, comment3_id. These are numbers, that are linked to a table called grade_comments, with grade_id being the number, and grade_desc being the actual comment.
Teacher's can choose 1, 2, or 3 comments. How do I build the query to extract this information? I am really stumped!
Any help would be excellent.
Doug