回答編集履歴
2
調整
test
CHANGED
@@ -56,7 +56,7 @@
|
|
56
56
|
|
57
57
|
|
58
58
|
|
59
|
-
#
|
59
|
+
# all
|
60
60
|
|
61
61
|
```SQL
|
62
62
|
|
1
追記
test
CHANGED
@@ -53,3 +53,15 @@
|
|
53
53
|
where not No in (select No from tbl_b)
|
54
54
|
|
55
55
|
```
|
56
|
+
|
57
|
+
|
58
|
+
|
59
|
+
# not all
|
60
|
+
|
61
|
+
```SQL
|
62
|
+
|
63
|
+
select No,Name from tbl_a as t1
|
64
|
+
|
65
|
+
where No <> ALL (select No from tbl_b)
|
66
|
+
|
67
|
+
```
|