select * from user where not exists(select 1 from users where name=user.name)
select name from user minus select name from users;
SELECT tbl_a.name FROM tbl_a WHERE tbl_a.name NOT IN (SELECT tbl_b.name FROM tbl_b) ---------------- select * from user where not exists(select 1 from users where name=user.name) ---------------- select name from user minus select name from users; ---------------- 上述三都适用,BECK的方法怎么应用?
minus
select name from users;
WHERE tbl_a.name NOT IN (SELECT tbl_b.name FROM tbl_b)
----------------
select * from user where not exists(select 1 from users where name=user.name)
----------------
select name from user
minus
select name from users;
----------------
上述三都适用,BECK的方法怎么应用?