Joining tables

Thread: Joining tables

Search this list only Search all lists
Joining tables
	2006-08-31 19:58:26

Hmmm.... I believe you also need a tblTeachers table... From: "Tim Curtin" <tjc_tekhotmail.com> Sent: Thursday, August 31, 2006 3:18 PM To: aspnet-databasesaspadvice.com Subject: [aspnet-databases] RE: Joining tables No. separate tables: 1- tblStudents StudentID INT IDENTITY(1,1) PRIMARY KEY FirstName VARCHAR(50) LastName VARCHAR(50) DateOfBirth DATETIME DateEntryToSchool DATETIME DateGraduate DATETIME GradeEntered INT GradeTerminated INT 2- tblStudentGrades StudentGradeID INT IDENTITY(1,1) PRIMARY KEY ClassID INT MarkingPeriod INT Grade INT 3- tblClasses ClassID INT IDENTITY(1,1) PRIMARY KEY ClassName VARCHAR(100) TeacherID INT DateClassStart DATETIME DateClassEnd DATETIME Credits INT >From: "Amofa Kodom baffoe" mail.dcu.ie> >Reply-To: aspnet-databasesaspadvice.com >To: aspnet-databasesaspadvice.com >Subject: [aspnet-databases] RE: Joining tables >Date: Thu, 31 Aug 2006 16:38:39 +0100 > >Hi Tim, > >Does it mean joining a table to itself? I have been thinking about that >myself. > > > >-- Original Message -- > >From: "Tim Curtin" hotmail.com> > >To: aspnet-databasesaspadvice.com > >Subject: [aspnet-databases] RE: Joining tables > >Date: Thu, 31 Aug 2006 08:28:43 -0400 > >Reply-To: aspnet-databasesaspadvice.com > > > > > >wouldn't it make sense to have a students table and a Grades table joined > >on > >StudentID. The grades table could have the studentID, ClassID, Grade, >and > > > >Grade Date. > > > > > >>From: "Amofa Kodom baffoe" mail.dcu.ie> > >>Reply-To: aspnet-databasesaspadvice.com > >>To: aspnet-databasesaspadvice.com > >>Subject: [aspnet-databases] RE: Joining tables > >>Date: Wed, 30 Aug 2006 19:01:50 +0100 > >> > >>I have students in different tables because I ended up creating a table > >for > >>each module due to the complexity of the demand of the output. I was >having > >>problems dealing with one-to-many relations between Sql server, xml and > > > >>xslt. > >>More difficult was xslt. There might be a way, but I had run out of time > >>and wanted to do it the most quickest possible way. > >> > >>rgds, > >> > >> >-- Original Message -- > >> >From: "Tim Curtin" hotmail.com> > >> >To: aspnet-databasesaspadvice.com > >> >Subject: [aspnet-databases] RE: Joining tables > >> >Date: Wed, 30 Aug 2006 10:47:28 -0400 > >> >Reply-To: aspnet-databasesaspadvice.com > >> > > >> > > >> >why do you have students in different tables? > >> > > >> > > >> >>From: "Amofa Kodom baffoe" mail.dcu.ie> > >> >>Reply-To: aspnet-databasesaspadvice.com > >> >>To: aspnet-databasesaspadvice.com > >> >>Subject: [aspnet-databases] Joining tables > >> >>Date: Wed, 30 Aug 2006 11:02:11 +0100 > >> >> > >> >>Hi Guys, > >> >> > >> >>I have about six tables all containing student grades. I want to join > > > >>all > >> >>tables. The tables have different number of students in each table, >one > >> > > >> >>table > >> >>has a listing of say 6 students, other has a listing of 20 students >and > >> >so > >> >>on.. > >> >> > >> >>When I join this table, I always get a number of tuples equal to the > > > >>table > >> >>with the minimum number of students. I don't know if I am clear. I do > > > >>not > >> >>get information on all the students in the table with 20 students, I > >do > >> >get > >> >>information on only 6 students throughout, because one of the tables > >I > >>am > >> >>joning has only 6 elements in it. Is there anyway, I can join all >these > >> > > >> >>tables > >> >> and still have all elements in all tables? > >> >> > >> >>rgds, > >> >> > >> >> > >> >> >-- Original Message -- > >> >> >From: "Rob Kellow" evolutionsoft.com> > >> >> >Subject: [aspnet-databases] RE: Gridview data column value? > >> >> >Date: Mon, 14 Aug 2006 10:50:38 -0700 > >> >> >To: aspnet-databasesaspadvice.com > >> >> >Reply-To: aspnet-databasesaspadvice.com > >> >> > > >> >> > > >> >> >Sorry. I can tell you though the snippet I sent you works fine and > >I > >> > > >> >>think > >> >> >I have some non-visible fields in the grid as well. There were >some > >> > >> >>things > >> >> >in the example that you probably don't have set up like some of the > >> >>session > >> >> >variables but I assumed that you could pull those out. > >> >> > > >> >> >Without seeing the code I'm not sure what is happening with you >grid. > >> > If > >> >> >you want to send some of your code maybe we can see a problem. > >> >> > > >> >> >--Rob > >> >> > > >> >> >-----Original Message----- > >> >> >From: David Wendelken [mailto:davewendelkenearthlink.net] > >> >> >Sent: Monday, August 14, 2006 5:04 AM > >> >> >To: aspnet-databasesaspadvice.com > >> >> >Subject: [aspnet-databases] RE: Gridview data column value? > >> >> > > >> >> >Thanks! > >> >> > > >> >> >But your example didn't work. > >> >> > > >> >> >I've got a grid on the screen with one row in it. That should be >row > >> >0. > >> >> > > >> >> >First cell is a button, second is a non-visible bound field, third > >a > >> >> >hyperlink field showing a data item as the text, fourth is a >button. > >> >> >cells 0 thru 3. > >> >> > > >> >> >They are all "" in the debugger. > >> >> > > >> >> >However, if I turn the second field to visible, then I get values >in > >>the > >> >> >debugger... > >> >> > > >> >> >That's nasty. > >> >> > > >> >> > > >> >> > > >> >> > > >> >> >Need SQL Advice? http://sqladvice.com > >> >> >Need RegEx Advice? http://regexadvice.com > >> >> >Need XML Advice? http://xmladvice.com > >> >> > > >> >> > > >> >> > > >> >> > > >> >> >Need SQL Advice? http://sqladvice.com > >> >> >Need RegEx Advice? http://regexadvice.com > >> >> >Need XML Advice? http://xmladvice.com > >> >> > >> >>Amofa Kodom Baffoe, > >> >>School of Computing, > >> >>Dublin City University, > >> >>Glasnevin, Dublin 9 > >> >> > >> >> > >> >> > >> >> > >> >>Need SQL Advice? http://sqladvice.com > >> >>Need RegEx Advice? http://regexadvice.com > >> >>Need XML Advice? http://xmladvice.com > >> > > >> > > >> > > >> >Need SQL Advice? http://sqladvice.com > >> >Need RegEx Advice? http://regexadvice.com > >> >Need XML Advice? http://xmladvice.com > >> > >>Amofa Kodom Baffoe, > >>School of Computing, > >>Dublin City University, > >>Glasnevin, Dublin 9 > >> > >> > >> > >> > >>Need SQL Advice? http://sqladvice.com > >>Need RegEx Advice? http://regexadvice.com > >>Need XML Advice? http://xmladvice.com > > > > > > > >Need SQL Advice? http://sqladvice.com > >Need RegEx Advice? http://regexadvice.com > >Need XML Advice? http://xmladvice.com > >Amofa Kodom Baffoe, >School of Computing, >Dublin City University, >Glasnevin, Dublin 9 > > > > >Need SQL Advice? http://sqladvice.com >Need RegEx Advice? http://regexadvice.com >Need XML Advice? http://xmladvice.com Need SQL Advice? http://sqladvice.com Need RegEx Advice? http://regexadvice.com Need XML Advice? http://xmladvice.com evolutionsoft.com>mail.dcu.ie>hotmail.com>mail.dcu.ie>hotmail.com>mail.dcu.ie> Need SQL Advice? http://sqladvice.com Need RegEx Advice? http://regexadvice.com Need XML Advice? http://xmladvice.com

[1]

about | contact Other archives ( Real Estate discussion Medical topics )