title: Big Query multiple tables
body: <p>I'm trying to query from multiple tables in Google's BigQuery. I am getting the error "Field 'w.max_temperature' not found in table 'weather.stations'." </p>
  
  <p>Here is my SQL:</p>
  
  <p><code>SELECT w.station_number, s.LAT, s.LON, w.year, w.month, avg(w.mean_temp) as [mean temp], max(w.max_temperature) as [max temp], min(w.min_temperature) as [min temp], avg(w.mean_visibility) as [avg visbility]
  FROM [weather.stations] s, [publicdata:samples.gsod] w
  WHERE w.station_number=s.USAF AND w.wban_number=s.WBAN 
  GROUP BY w.month, w.year, w.station_number, s.LAT, s.LON;</code></p>
  
  <p>I tried to reference "max_temperature" to [publicdata:samples.gsod], but for whatever reason it is referencing it to [weather.stations]. Any Ideas? Thanks!</p>