回答編集履歴
1
"AS"で名前を付けたほうがもっと便利ですね。（付け忘れすいません）
test
CHANGED
|
@@ -16,9 +16,9 @@
|
|
|
16
16
|
|
|
17
17
|
tbl_a.`B_ID2`,
|
|
18
18
|
|
|
19
|
-
(select tbl_b.`BUHIN` from tbl_b where tbl_a.`B_ID1`=tbl_b.`ID`),
|
|
19
|
+
(select tbl_b.`BUHIN` from tbl_b where tbl_a.`B_ID1`=tbl_b.`ID`) AS BUHIN1,
|
|
20
20
|
|
|
21
|
-
(select tbl_b.`BUHIN` from tbl_b where tbl_a.`B_ID2`=tbl_b.`ID`)
|
|
21
|
+
(select tbl_b.`BUHIN` from tbl_b where tbl_a.`B_ID2`=tbl_b.`ID`) AS BUHIN2
|
|
22
22
|
|
|
23
23
|
from tbl_a
|
|
24
24
|
|