Re: sql query - rows in tblB not in tblA?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Craig H. (spam_at_[at)
Date: 09/08/04 

Date: Wed, 08 Sep 2004 11:44:40 +0100

On 08/09/2004 11:34, Roji. P. Thomas wrote:
> SELECT A.*
> FROM tblA A
> LEFT OUTER JOIN TblB B
> ON A.column1 = B.Column1
> AND A.Column2 = B.Column2
> WHERE B.Column1 IS NULL
>
>

thank you.

Relevant Pages

  • Re: Dynamic table name in query
    ... "Roji. ... P. Thomas" wrote in message ... >> Dynamic SQL, you could just explain your position or at least write the ... >>> You are trying to write a procedure without any cohesion at all. ...
    (microsoft.public.sqlserver.programming)
  • Re: searching with varying parameters
    ... "Roji. ... P. Thomas" wrote in message ... > Net Asset Management ... >> body, Search by attachment name, search if message has attachments). ...
    (microsoft.public.sqlserver.programming)
  • Re: Output parameters
    ... > Set CmdParams = Nothing ... > "Roji. ... P. Thomas" wrote in message ... >> Net Asset Management ...
    (microsoft.public.sqlserver.programming)
  • Re: DISTINCT and LEFT JOIN problem
    ... > "Roji. ... P. Thomas" wrote in message ... >>>>> SELECT DISTINCT resResourceID, resDateIn, resDateOut, empEmployeeID, ...
    (microsoft.public.sqlserver.programming)
  • Re: Structure Help
    ... "Drew" wrote in message ... > "Roji. ... P. Thomas" wrote in message ... CharacteristicsInPeople - Again a list ...
    (microsoft.public.sqlserver.programming)