SQL

Question

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;

Answer 1

I fixed it. Thank You! :)

Answer 2

What is the error you get ?