(Simplified)
I have a view with the following 4 fields
ClientID ContactID ContactType FullName
I want to do a UNION all and
Select ClientID, ContactID,ContactType,FullName
From ClientContacts
Where the ClientCOntacts record doesn't exist in the View
The similar fields are of course ClientID and ContactID
Buried and can't remember the simplest thing