RE: Compare Data in two differant tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul (Paul_at_discussions.microsoft.com)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 12:09:10 -0800

Untested due to lack of DDL...

SELECT P.XTeleLink, TS.XTeleLink
FROM XTeleLink TS
  LEFT OUTER JOIN Prospect P ON TS.XTeleLink = P.XTeleLink
WHERE TS.XResultCode = 9
  AND P.XTeleLink IS NULL

Paul

"Dennis Burgess" wrote:

> Here is my query
>
> Select Prospect.XTeleLink as exp1, TeleScrp.XteleLink as exp2
> from Prospect, XTeleLink
> Where exp2 <> exp1 and TeleScrp.XResultCode = 9
>
> What I want is to find XTeleLink numbers where the XResultCode = 9 in the
> TeleScrp table, but there is NOT at record in my Prospect table that has
> that same XTeleLink
>
> I have some missing data, there should always be data in the prospect table,
> and I am trying to find out what is missing!
>
> Any help in adavnce, thanx!
>
> Dennis
>
>
>

Relevant Pages

  • Compare Data in two differant tables
    ... What I want is to find XTeleLink numbers where the XResultCode = 9 in the ... but there is NOT at record in my Prospect table that has ... I have some missing data, there should always be data in the prospect table, ...
    (microsoft.public.sqlserver.programming)
  • RE: Compare Data in two differant tables
    ... "Dennis Burgess" wrote: ... > from Prospect, XTeleLink ... > I have some missing data, there should always be data in the prospect table, ...
    (microsoft.public.sqlserver.programming)
  • Re: Compare Data in two differant tables
    ... How do you also look for a field from the second Prospect Table? ... Dennis ... >> TeleScrp table, but there is NOT at record in my Prospect table that has ... >> I have some missing data, there should always be data in the prospect ...
    (microsoft.public.sqlserver.programming)