回答編集履歴
3
修正
test
CHANGED
|
@@ -18,7 +18,7 @@
|
|
|
18
18
|
|
|
19
19
|
SELECT id, messa, chat_id, max(updated_date) as updated_date FROM chat
|
|
20
20
|
|
|
21
|
-
|
|
21
|
+
LEFT JOIN chat_messa ON chat.id = chat_messa.chat_id
|
|
22
22
|
|
|
23
23
|
GROUP BY chat_messa.chat_id
|
|
24
24
|
|
2
追記
test
CHANGED
|
@@ -11,3 +11,17 @@
|
|
|
11
11
|
|
|
12
12
|
|
|
13
13
|
テーブルの関係が、1:1 なのか、1:n なのか不明だし、提示された例だと group にする意味も不明なので、これ以上説明不可。
|
|
14
|
+
|
|
15
|
+
|
|
16
|
+
|
|
17
|
+
```sql
|
|
18
|
+
|
|
19
|
+
SELECT id, messa, chat_id, max(updated_date) as updated_date FROM chat
|
|
20
|
+
|
|
21
|
+
INNER JOIN chat_messa ON chat.id = chat_messa.chat_id
|
|
22
|
+
|
|
23
|
+
GROUP BY chat_messa.chat_id
|
|
24
|
+
|
|
25
|
+
ORDER BY chat.id DESC
|
|
26
|
+
|
|
27
|
+
```
|
1
修正
test
CHANGED
|
@@ -2,7 +2,7 @@
|
|
|
2
2
|
|
|
3
3
|
SELECT id, messa, chat_id, updated_date FROM chat
|
|
4
4
|
|
|
5
|
-
|
|
5
|
+
INNER JOIN chat_messa ON chat.id = chat_messa.chat_id
|
|
6
6
|
|
|
7
7
|
ORDER BY id DESC
|
|
8
8
|
|