Re: Query - multiple joins won't return any records
Sorry, my descriptions here look clear to me. You can't understand so I'm obviously not getting accross.
Teams, divisions, whatever - are involved with a 'work'.
My client selects what 'entities' (teams, divisions, etc.) are involved.
They can select whatever entities they deem 'involved', including multiples.
The entities don't mean anything specific to me (what is a 'team'?), they mean something to my client.
A person answers questions on a 'work' with a score.
The only relationship between the 'entities' is that they were involved with the same 'work'.
I need to produce reports showing score averages. The client wants to see 1, 2 and up to 3 (if more than divisions & teams are 'entities') tiers as shown in my OP.
I can design it to work but the design is horrible.
If I create an id field for each 'entity' in the scores (or relations) table (for example DivisionID, TeamID, WhateverID) and make them varchars instead of ints I can comma separate multiples of a given 'entity' per row.
With that I *can* create the reports but I *hate* the design. It results in a badly bloated database, a lot of array programming and real slow reports.
I was hoping someone might have a better idea.
Subject
Written By
Posted
February 13, 2015 09:32PM
February 14, 2015 10:21AM
February 14, 2015 10:57AM
February 14, 2015 03:03PM
February 15, 2015 01:40AM
February 15, 2015 09:59AM
February 15, 2015 01:40PM
Re: Query - multiple joins won't return any records
February 15, 2015 02:33PM
February 15, 2015 02:54PM
February 15, 2015 03:09PM
February 15, 2015 07:59PM
February 19, 2015 03:06PM
February 19, 2015 04:17PM
February 21, 2015 07:01PM
February 14, 2015 11:39PM