Challenging Query Problem!

From: Eddie <edawad_at_hotmail.com>
Date: 2000/04/10
Message-ID: <8ctmg5$296$1@nnrp1.deja.com>#1/1

Hi, I have a query which has the following output:

name1 assignment1 10
name2 assignment1 9
name3 assignment1 9
name1 assignment2 12
name2 assignment2 15
name3 assignment2 11

What I want is the following:

NAME Assignment1 Assignment2

name1   10                  12
name2   9                   15
name3   9                   11

I have absolutely no idea how do this. Neither the number of students (name1, name2....) is fixed nor the number of assignments. Any help is greatly appreciated. Thanks.

--
Eddie
Web Application Developer


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Mon Apr 10 2000 - 00:00:00 CDT