TheSQLGuru (3/14/2013)
Hmm, I wonder what happens if the codeid's repeat instead of being unique across all 3 code tables. Hopefully the way the aggregates are done will factor the Cartesian out but I think it could duplicate hits...
And it could also be a valid scenerio as well, only the OP can tell us for sure.