回答編集履歴
1
リファクタリング
test
CHANGED
|
@@ -1,13 +1,17 @@
|
|
|
1
|
-
|
|
1
|
+
atableとctableを結合した後にbtableをleft joinしてはどうでしょうか？
|
|
2
2
|
|
|
3
3
|
|
|
4
4
|
|
|
5
5
|
```php
|
|
6
6
|
|
|
7
|
-
$sql="SELECT anc.acol,anc.bcol
|
|
7
|
+
$sql="SELECT anc.acol,anc.bcol";
|
|
8
8
|
|
|
9
|
-
$sql="LE
|
|
9
|
+
$sql=" FROM (SELECT acode,acol,bcol FROM atable";
|
|
10
10
|
|
|
11
|
+
$sql=" UNION SELECT acode,acol,bcol FROM ctable) anc";
|
|
12
|
+
|
|
13
|
+
$sql=" LEFT JOIN btable ON anc.acode = btable.acode";
|
|
14
|
+
|
|
11
|
-
$sql="WHERE anc.bcode = ".$bcode;
|
|
15
|
+
$sql=" WHERE anc.bcode = ".$bcode;
|
|
12
16
|
|
|
13
17
|
```
|