I need to write a query that joins 3 tables, a master with 2 detail tables
and I need to end up with 1 row per each row of the master table. The tables
are students, previous_institutions, and test_scores. So what I want is the
first previous institution and the average of the scores.
table st
At 2:08 -0800 2/9/02, Joe Chesak wrote:
>I am attempting to combine COUNT, GROUP BY, and LEFT
>JOIN.. Adopting the theme on
>http://www.mysql.com/doc/C/o/Counting_rows.html my
>goal is to display only species/sex combinations that
>occur more than once. Additionally I wish to include
>the count fo
I am attempting to combine COUNT, GROUP BY, and LEFT
JOIN.. Adopting the theme on
http://www.mysql.com/doc/C/o/Counting_rows.html my
goal is to display only species/sex combinations that
occur more than once. Additionally I wish to include
the count for each row, and some keyed field from
another
At 2:08 -0800 2/9/02, Joe Chesak wrote:
>I am attempting to combine COUNT, GROUP BY, and LEFT
>JOIN.. Adopting the theme on
>http://www.mysql.com/doc/C/o/Counting_rows.html my
>goal is to display only species/sex combinations that
>occur more than once. Additionally I wish to include
>the count fo
I am attempting to combine COUNT, GROUP BY, and LEFT
JOIN.. Adopting the theme on
http://www.mysql.com/doc/C/o/Counting_rows.html my
goal is to display only species/sex combinations that
occur more than once. Additionally I wish to include
the count for each row, and some keyed field from
another
