I have two tables that are linked by Item, Client, Country
The query below returns a lot of Nulls. There are some records that are in one table and not in the other for both tables.
I still need to know the Item, Client, Country, Description, but it returns Null instead of the info for those fields
Any suggustions, Im not even sure I can post this here please advise if I need to post else where
Select AF.* from
from Actual2 A full outer Join Forecast2 F on (A.Item = F.Item and A.CLIENT = F.Client and A.COUNTRY = F.Country) ) as AF