I now found that I really have a very dish for the database!
Create View MyView Assreatment City, Temp_lo, Temp_hi, PRCP, Date, LocationFrom Weather, Citieswhere City = Name
SELECT * from myView;