Professional Web Applications Themes

Find data not exist in tableA, but in tableB - Microsoft SQL / MS SQL Server

Hi, I have two tables, tableA and tableB. They have a same column named, COLUMN11. Here are data in these tables. tableA COLUMN1 AAA BBB tableB COLUMN1 AAA How do I find data value BBB which does not exist in the tableB? Thank. Mindy...

  1. #1

    Default Find data not exist in tableA, but in tableB

    Hi,

    I have two tables, tableA and tableB. They have a same column named,
    COLUMN11. Here are data in these tables.
    tableA
    COLUMN1
    AAA
    BBB

    tableB
    COLUMN1
    AAA

    How do I find data value BBB which does not exist in the tableB?

    Thank.

    Mindy


    Mindy Guest

  2. #2

    Default Re: Find data not exist in tableA, but in tableB

    Try:

    select
    a.COLUMN1
    from
    tableA as a
    where not exists
    (
    select
    *
    from
    tableB as b
    where
    b.COLUMN1 = a.COLUMN1
    )

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Mindy Zhang" <com> wrote in message news:phx.gbl...
    Hi,

    I have two tables, tableA and tableB. They have a same column named,
    COLUMN11. Here are data in these tables.
    tableA
    COLUMN1
    AAA
    BBB

    tableB
    COLUMN1
    AAA

    How do I find data value BBB which does not exist in the tableB?

    Thank.

    Mindy



    Tom Guest

  3. #3

    Default Re: Find data not exist in tableA, but in tableB

    Thanks.
    "Tom Moreau" <spam.me.cips.ca> wrote in message news:phx.gbl...
    Try:

    select
    a.COLUMN1
    from
    tableA as a
    where not exists
    (
    select
    *
    from
    tableB as b
    where
    b.COLUMN1 = a.COLUMN1
    )

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Mindy Zhang" <com> wrote in message news:phx.gbl...
    Hi,

    I have two tables, tableA and tableB. They have a same column named,
    COLUMN11. Here are data in these tables.
    tableA
    COLUMN1
    AAA
    BBB

    tableB
    COLUMN1
    AAA

    How do I find data value BBB which does not exist in the tableB?

    Thank.

    Mindy



    Mindy Guest

Similar Threads

  1. FTP with File::Find-like Capabilities: Does It Exist?
    By Jim Keenan in forum PERL Modules
    Replies: 4
    Last Post: April 27th, 01:29 PM
  2. ntpdate - can't find a server that does exist.
    By Dr. David Kirkby in forum AIX
    Replies: 1
    Last Post: August 7th, 12:29 PM
  3. A2k: data entry subform for records that don't exist
    By lfaherty in forum Microsoft Access
    Replies: 1
    Last Post: July 22nd, 12:32 PM
  4. Replies: 0
    Last Post: July 20th, 02:51 AM
  5. how to find out if control exist
    By Ante Perkovic in forum ASP.NET General
    Replies: 1
    Last Post: June 25th, 03:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139