Displaying PostgreSQL NULL Values in a Join

[PlumPlant]

Hello friends. I need to write a query where I retrieve years from a different view. Within the main query, I want to match the values with the years in the view and display them. My goal is to also include unmatched years and show the "value" column as NULL. Here is my query: select s.station_no::int station_no, s.station_name, y.year year, s.month::decimal month, s.value::decimal value FROM monthly_average_temperature s FULL JOIN yearly_temperature as y ON s.year::int=y.year WHERE s.station_no='18401' and month='13' ORDER by month