Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: HELP!!! Joining 3 tables, SUMming and grouping. VERY IMPORTANT

  1. #1

    Default HELP!!! Joining 3 tables, SUMming and grouping. VERY IMPORTANT

    I have 3 tables

    Task
    idTask
    responsible
    parent_story_id
    hoursWorked
    ...

    <-- one-to-many

    Story
    idStory
    parent_sprint_id
    ...

    <-- one-to-many

    Sprint
    idSprint
    initialDate
    ...


    I need to get the total amount of worked hours per RESPONSIBLE per SPRINT.

    How would my query be?

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Just a wild guess - this homework assignment is due Monday?
    So long, and thanks for all the fish.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.