Jump to content

kmorrissey89

Members
  • Posts

    3
  • Joined

  • Last visited

kmorrissey89's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. the team names are the same it is only the shift column that changes
  2. yeah the count for the shifts doubles when I did the second join
  3. Hello, Sorry but I'm sure this is an easy question but I am pretty new to SQL and trying to learn this on my own. I recently tried doing a query and got the results I was looking for but when I went to join a third table to get some more information in there all of the results doubled. Here is the code that I have, before I joined the team table to get the teamname in there everything worked fine. Select p.commonname + ' ' + p.lastname as battername, teamname, count(defenseshift) as Shift from players as p left join results as r on r.batterid = p.playerid left join team as t on t.teamid = r.batteamid where r.defenseshift = 7 group by p.commonname, p. lastname, t.teamname order by shift desc Like I said I'm sure this is a 101 kind of problem, but any help in describing my mistake would be appreciated. Thanks
×
×
  • Create New...