Выбор из таблицы А всех записей, которых нет в таблице Б

SELECT A.[Column1] FROM [DB].[Table1] AS A
WHERE NOT EXISTS
(SELECT B.[Column1] FROM [DB].[Table2] AS B
WHERE B.[Column1] = A.[Column1])

Красиво, изящно и быстро.

Ссылка:
Finding records in one table not present in another table

Запись опубликована в рубрике Tips and Tricks с метками . Добавьте в закладки постоянную ссылку.

6 Responses to Выбор из таблицы А всех записей, которых нет в таблице Б

  1. conversational tone пишет:

    This design is incredible! You definitely know how to keep a reader entertained. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Wonderful job. I really enjoyed what you had to say, and more than that, how you presented it. Too cool!|

  2. webpage пишет:

    Ӏnvestіu dinheiro, ligou painel de controle, pronto!

  3. I get pleasure from, result in I found exactly what I used
    to be having a look for. You have ended my four day long hunt!
    God Bless you man. Have a nice day. Bye

  4. Online selling пишет:

    s services are wondeful!

  5. Leidecker пишет:

    Very good webpage you have in here.

Добавить комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *