teratail
回答率
85.48%
質問するログイン新規登録
トップに関する質問3つのテーブルを結合した後の値の取得について教えて下さい。

編集履歴

質問編集履歴

1

誤字の修正

2015/08/24 02:57

投稿

ssk
ssk

スコア332

test CHANGED
File without changes
test CHANGED
@@ -68,7 +68,7 @@
68
68
 
69
69
  ```ここに言語を入力
70
70
 
71
- SELECT * FROM shop_info_post INNER JOIN user ON shop_info_post.code = user.code WHERE shop_slug=?
71
+ SELECT * FROM post INNER JOIN user ON post.code = user.code WHERE slug=?
72
72
 
73
73
  ```
74
74
 
@@ -80,7 +80,7 @@
80
80
 
81
81
  ```ここに言語を入力
82
82
 
83
- SELECT * FROM shop_info_post INNER JOIN user ON shop_info_post.code = user.code INNER JOIN comment ON post.post_id = comment.post_id WHERE shop_slug=?
83
+ SELECT * FROM post INNER JOIN user ON post.code = user.code INNER JOIN comment ON post.post_id = comment.post_id WHERE slug=?
84
84
 
85
85
  ```
86
86
 
@@ -92,7 +92,7 @@
92
92
 
93
93
  ```ここに言語を入力
94
94
 
95
- SELECT * FROM post INNER JOIN user ON post.code = user.code INNER JOIN comment ON post.post_id = comment.post_id WHERE shop_slug=?
95
+ SELECT * FROM post INNER JOIN user ON post.code = user.code INNER JOIN comment ON post.post_id = comment.post_id WHERE slug=?
96
96
 
97
97
  ```
98
98