Re: Newbie Help

You would be right of course it is homework. However I have been trying to solve this problem for 4 days now and am getting a little stressed out.

I have tried SUM and GROUP BY but keep getting errors in the combinations that I have used.

Cheers

Rocky

  "Alan Mills" <Alan.Mills_at_nospamservices.fujitsu.com> wrote in message news:aq8kbb$d13$1_at_news.icl.se...   Working onthe assumption that this is a homework assignment, I'm not going to answer it directly.

  However, indirectly, think in terms of SUM and GROUP BY.

  Alan
    "Rocky" <peawet08_at_hotmail.com> wrote in message news:3dc7d1d1$0$28312$fa0fcedb_at_lovejoy.zen.co.uk...     I am just starting to learn SQL and am stuck on a question in my tutorial.

    I have used the following:

    select assignment_type, assignments.project_identifier, description, hours_allocated     from assignments, projects
    where assignments.project_identifier = projects.project_identifier;

    to retreive the following:

    AS PROJECT_IDENTIFIER DESCRIPTION HOURS_ALLOCATED

• ------------------ ------------------------- --------------- C3 1433 Results 9 C3 1433 Results 4 A1 2179 Student Tracking System 3 A1 2179 Student Tracking System 7 B2 2265 Staff Time Tabling 7 B2 2265 Staff Time Tabling 5 B2 2265 Staff Time Tabling 6 B2 3144 Room Time Tabling 6 A1 4134 Computerised Registers 5 A1 4134 Computerised Registers 8 A1 4134 Computerised Registers 9

    AS PROJECT_IDENTIFIER DESCRIPTION HOURS_ALLOCATED

• ------------------ ------------------------- --------------- C3 6588 Course Developments 10 C3 6588 Course Developments 8

    My problem is that I need to display in another colunm, the total hours for each assignment type.

    Can anybody please show me the easiest way to do this.

    Thanks

    Rocky Received on Tue Nov 05 2002 - 09:30:16 CST