teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

1

SQL文にミスがあったため修正しました

2020/02/26 01:21

投稿

ikeshi
ikeshi

スコア7

title CHANGED
File without changes
body CHANGED
@@ -42,10 +42,10 @@
42
42
  master_table AS master
43
43
  LEFT OUTER JOIN
44
44
  serviceA AS serviceA
45
- ON master.id = subA.master_id
45
+ ON master.id = serviceA.master_id
46
46
  LEFT OUTER JOIN
47
47
  serviceB AS serviceB
48
- ON master.id = subB.master_id
48
+ ON master.id = serviceB.master_id
49
49
  WHERE
50
50
  serviceA.serviceA_data = "hoge"
51
51
  AND