```
select *
from [dbo].[Revenue_PL_S_F_M] rsfm
  full join [dbo].[Expense_Misc_Variable] emv 
    on emv.FISCYR = rsfm.FISCYR
    and emv.FISCPER = rsfm.FISCPER
    and emv.Warehouse = rsfm.Warehouse
    and emv.Customer = rsfm.Customer
where RSFM.FISCYR = 2017 
  and RSFM.FISCPER = 1 
  and RSFM.GLGroup = 'M'

```

There are 3 rows in emv, 1 that doesn't have a matching rsfm.customer. This line is not being added to the view.

Thanks in advance
Gerry