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

質問編集履歴

1

sss

2021/02/08 13:04

投稿

退会済みユーザー
title CHANGED
File without changes
body CHANGED
@@ -1,9 +1,10 @@
1
1
  ```postgressql
2
- delete from where inner join teams.goods_no= clasees.goods_no where teams.goods_01 = 'test1';
2
+ delete from where teams inner join teams.goods_no= clasees.goods_no where teams.goods_01 = 'test1';
3
3
  ```
4
- SQL : delete from where inner join teams.goods_no= clasees.goods_no where teams.goods_01 = 'test1'
5
- SQL : syntax error at or near "where"
6
4
 
5
+ SQL : delete from clasees where inner join teams.goods_no= clasees.goods_no where teams.goods_01 = 'test1'
6
+ SQL : syntax error at or near "join"
7
+
7
8
  ![イメージ説明](dcaad6b9b11dd3f9e0bc85975c46901b.png)
8
9
 
9
10
  ![イメージ説明](1959bba8c5cd1008b5f26213399b8c66.png)