Thanks Petite...You, like Keith Medcalf, are a great mentor, helping me to
develop my burgeoning skills in SQL. I appreciate the reason for the cause of
each of the problems I encountered and how to correct them.
'Granularity' is a new term for me and I now know why multiple entries
occurred. Keith earlier introduced single 'scalar' result of correlated
sub-queries. Also, I am now more aware of the type of join that should be used
to include desired rows. Be well.
> From: petite.abei...@gmail.com
> Date: Mon, 11 Aug 2014 21:39:29 +0200
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] UEFA EURO 2012 Football Championship problem
>
>
> On Aug 11, 2014, at 8:39 PM, Errol Emden <eem...@hotmail.com> wrote:
>
> > 1. Matches in which neither team scored is not being displayed.
>
> Because you have an inner join to goal. If there no goal, then no entry will
> match.
>
> > 2. Scores for the same matchid where both teams scored are appearing on
> > separate lines instead of in a single line.
>
> Because you have a join to goal, which has a granularity of one entry per
> goal, per match. So, if multiple goal, multiple entries. You try to
> compensate by grouping per match and team, so you end up with two entries if
> both team have scored.
>
> > What do I need to do to correct these issues?
>
> Get you granularity in order.
> _____________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users