Thread: Can this SQL Query be Simplified?

_________________ Simon Larkin QiSQL Database Solutions Website : http://www.qisql.com Mac 10.5.8, Imac 2.4ghz, 4gb, RB 2009 R4

simonjohn wrote: Just to make sure I understand -does your database model look a bit like this? simonjohn, yes the database is similar to the one pictured above. simonjohn wrote: If so, why do you need the sub select? Couldn't you just use: Code: select b.name as name,   coalesce ( s.score, 'No Scores For This Guy (or whatever U want)!')   as score,   t.name as team_name  ...

How about AND p.pickno IN (1,2,3,4,5,6,7,8,9,10) ? Code: select b.name as name,   coalesce ( s.score, 'No Scores For This Guy (or whatever U want)!')   as score,   t.name as team_name   from Brackets b,   teams t ,   picks p   left outer join stats s on b.id = s.BracketID   where b.id = p.BracektID   and p.teamid = t.id   and...

Seems to me this has something to do with March Madness and how individuals may select a "bracket" Is that what this is for ? Each "bracket" is a set of choices of teams that are matched against each other and who that person thinks will be the winner. A person fills out EVERY winner from the initial match ups to come up with who they think will be the national champion See...