How to join on two fields where one could be null, Sql Server

How to join on two fields where one could be null

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 5, rows affected: 8, absolute service time: 0,16 sec

edit mode | history

  
id
country
t2_Id
t2_country

1
1
UK
1
UK

2
1
IE
1
IE

3
1
US
1
NULL

4
2
UK
2
UK

5
2
FR
2
NULL

λ

                                      .NET NoSQL database for rapid development