Junction table
From: annalissa <aarklon_at_gmail.com>
Date: Sun, 05 Jul 2009 10:51:10 +0530
Message-ID: <h2pd8g$kld$2_at_aioe.org>
hi all,
Date: Sun, 05 Jul 2009 10:51:10 +0530
Message-ID: <h2pd8g$kld$2_at_aioe.org>
hi all,
i saw an explanation of junction table here:- http://megocode3.wordpress.com/2008/01/04/understanding-a-sql-junction-table/ how correct is this explanation ?
but SELECT StudentName, RoomNumber
SELECT StudentName, RoomNumber
FROM StudentClassroom in this query
FROM StudentClassroom
JOIN Students ON Students.StudentID = StudentClassroom.StudentID
JOIN Classrooms ON Classrooms.ClassroomID = StudentClassroom.ClassroomID
doesn't seem to be correct is n't it? Received on Sun Jul 05 2009 - 07:21:10 CEST