5 Replies Latest reply: Apr 24, 2011 9:54 AM by yoOwnage RSS

    Create a new table from 3 others


      I need some help, as subject says, in how to create a new table from the relation of 3 other tables.

      Example: I have three tables, "StudentId", "Subject Name" and "Grade". And I want to create a new one with all students grade for a specific subject. It means.. instead of show Student ID's, this new table will show all student grades of, for example, Math subject.


      Thanks in advance