SQL statement SELECT * FROM A WHERE not the exists (selelct * FROM B the WHERE condition)-CodePudding

Home > database > SQL statement SELECT * FROM A WHERE not the exists (selelct * FROM B the WHERE condition)

SQL statement SELECT * FROM A WHERE not the exists (selelct * FROM B the WHERE condition)

Time：09-21

To extract the data in the table B in the table does not exist, sub statement table in the table with the subject of A sentence must be different, otherwise the knowledge to judge the values in the sub statement is true or not, really all the output data in A table,

Page link：https//www.codepudding.com/database/18873.html

Prev:Copy the lock conflicts in the process of distribution

Next:SQL Server setup failed

Tags：

problems

Links：
CodePudding