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]