Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2009
    Posts
    3

    Arrow Unanswered: problem in two tables

    i have two tables project and task


    project|| task

    projectid || TaskId
    projectt desc

    here project id is a primary key and task id is primary key

    now i want to list list ofproject with the task id

    Show a list of projects together with the number of tasks for each project. Show the project ID, the project description, and the number of tasks.

  2. #2
    Join Date
    Dec 2008
    Posts
    135
    is there projectid column in the task table.. if not how can the join bw two tables to get no of tasks

  3. #3
    Join Date
    Aug 2009
    Posts
    3

    reg

    ya there is the projectid in it

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by illusiondinesh
    Show a list of projects together with the number of tasks for each project. Show the project ID, the project description, and the number of tasks.
    homework question


    what have you tried so far?

    hint: GROUP BY
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •