I'm pretty stuck at the moment due to by lack of SQL knowledge!

I have two tables with the following criteria:

```
Table1

UPC  
Country

Table2

UPC  
Country

```

I need to see all of the rows in Table 1 with the corresponding UPC from Table two and where a country is missing from table 2.

So for example:

```
UPC1    |Country1   |UPC2   |Country2  
12345   |UK     |12345  |UK  
12345   |IE     |12345  |IE
12345   |DE     |NULL   |NULL
12345   |FR     |12345  |FR

```

I've tried the following code:

```
select *
from CPRSLRScheduled cprs join R2LRDig r2
    on cprs.UPC = r2.upc
where cprs.country_iso_code not in (r2.country_id)

```

I know this is a real beginners' question but I really need a helping hand!