I am trying to unmatch two queries and it keeps coming out blank.
Code:
SELECT [~Matching PhoneNumbers RealUsers-AD View].UserName, [~Matching PhoneNumbers RealUsers-AD View].LastName, [~Matching PhoneNumbers RealUsers-AD View].FirstName, [~Matching PhoneNumbers RealUsers-AD View].Department, [~Matching PhoneNumbers RealUsers-AD View].AD_Phone
FROM [~Matching PhoneNumbers RealUsers-AD View] LEFT JOIN [~Matching PhoneNumbers RealUsers-WebView] ON ([~Matching PhoneNumbers RealUsers-AD View].AD_Phone = [~Matching PhoneNumbers RealUsers-WebView].AD_Phone) AND ([~Matching PhoneNumbers RealUsers-AD View].Web_Phone = [~Matching PhoneNumbers RealUsers-WebView].Web_Phone)
WHERE ((([~Matching PhoneNumbers RealUsers-WebView].Web_Phone) Is Null));