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 с метками tsql. Добавьте в закладки постоянную ссылку.
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!|
Glad to reply
Ӏnvestіu dinheiro, ligou painel de controle, pronto!
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
s services are wondeful!
Very good webpage you have in here.