0

SQL

Hello, I am trying to join two tables Table A consists of three columns City, Population and Snowfall. Table B consists of City, TeamName, GamesPlayed. I want to create a query that list the teamName, City, Population and Snowfall but when I try to do that I receive and error I have the following code. SELECT TeamName, Teams_T.City, Population, Snowfall FROM Teams_T, MetroArea_T WHERE MetroArea_T.City = Teams_T.City GROUP BY Teams_T.City;

4th Nov 2018, 6:32 PM
Isaac
Isaac - avatar
2 odpowiedzi
+ 1
I fixed it. Thank You! :)
6th Nov 2018, 9:07 PM
Isaac
Isaac - avatar
0
What is the error you get ?
6th Nov 2018, 9:06 PM
sneeze
sneeze - avatar