編集履歴

回答編集履歴

文字編集

2017/12/13 09:15

投稿

スコア56

answer CHANGED Viewed

@@ -9,7 +9,7 @@
 AND
     message like '%error%'
 INNER JOIN
-    (select testid,max(time) as time from sc2_devtouch2.t2 where message like '%Serror%' group by id) as testtable3
+    (select testid,max(time) as time from testdb.t2 where message like '%Serror%' group by id) as testtable3
 ON
     testtable2.id = testtable3.testid
 AND