PostgreSQL使用delete删除数据的时候关联多个表

看个例子就知道了

删除game_pg_getpoint表中的数据，需要关联getpoint表

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 
 

服务器租用/服务器托管中国五强！虚拟主机域名注册顶级提供商！15年品质保障！--亿恩科技[ENKJ.COM]