SQL Select where not exists?
(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,Full
From ClientContacts
Where the ClientCOntacts record doesn't exist in the View
The similar fields are of course ClientID and ContactID
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,Full
From ClientContacts
Where the ClientCOntacts record doesn't exist in the View
The similar fields are of course ClientID and ContactID
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Buried and can't remember the simplest thing