When PostgreSQL uses delete to delete data, it associates multiple tables.

Let's look at the example.

To delete data from the game_pg_getpoint table, you need to associate it with the getpoint table.

1. Delete from game_pg_getpoint USING getpoint
2. WHERE (getpoint. fixflg = 1 OR game_pg_getpoint.immediately_flag = 1)
3. AND game_pg_getpoint.memberid = getpoint. memberid
4. AND game_pg_getpoint.comment = getpoint. comment
5. AND game_pg_getpoint.thanksid = getpoint. thanksid
6. AND game_pg_getpoint.thanksname = getpoint. thanksname
7. AND game_pg_getpoint.getpoint_regist_date = getpoint. registdate