Joining tables

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" <tjc_tekhotmail.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"
<kodom.baffoe2mail.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" <robevolutionsoft.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

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"
<kodom.baffoe2mail.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" <tjc_tekhotmail.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"
<kodom.baffoe2mail.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" <robevolutionsoft.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