Solved

SQL Select where not exists?

Posted on 2012-12-26

1 solution

Medium Priority

603 Views

Last Modified: 2012-12-26

(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

Comment

Question by:lrbrister

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

2 Comments

LVL 21

Accepted Solution

by:Dale Burrell

Dale Burrell earned 2000 total points

ID: 387222752012-12-26

select  ClientID, ContactID, ContactType, FullName
from ClientContactsView C
union all
select  ClientID, ContactID, ContactType, FullName
from ClientContacts C
where not exists (
  select 1
  from ClientContactsView C1
  where C.ClientID = C1.ClientID and C.ContactID = C1.ContactID
)

Open in new window

Author Closing Comment

by:lrbrister

ID: 387222962012-12-26

Thanks
Buried and can't remember the simplest thing

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to use Slowly Changing Dimension Transformation in SSIS

Article by: Dung

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.

Installing SQL Server vNext on Linux: Part 2

Article by: Yashwant

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.

Dealing with Dates: Data Types and String Conversions (SQL Server)

Video by: Steve

Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

Microsoft SQL Server

Excel Error Handling Part 3 -- Run and Fix Bugs

Video by: crystal

This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…