using
![[PostgreSQL] DELETE JOIN](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdna%2FudihB%2Fbtsj5QqtMQj%2FAAAAAAAAAAAAAAAAAAAAADIqB5tvQFF_j2oUGJwrwXRfGzo24nWbqa5Sowdfp4aH%2Fimg.png%3Fcredential%3DyqXZFxpELC7KVnFOS48ylbz2pIh7yKj8%26expires%3D1753973999%26allow_ip%3D%26allow_referer%3D%26signature%3DAmkMmra909%252FmtS%252FpPfikcVSZrDQ%253D)
[PostgreSQL] DELETE JOIN
Master Table의 오래된 데이터를 삭제하려고보니, 엮여있는 테이블의 참조키(foreign key) 제약 조건 때문에 DELETE문에 JOIN을 사용하려고 한다. DELETE FROM TB_SALE_CUST WHERE STATUS_CD = '07' AND SALE_DT
Master Table의 오래된 데이터를 삭제하려고보니, 엮여있는 테이블의 참조키(foreign key) 제약 조건 때문에 DELETE문에 JOIN을 사용하려고 한다. DELETE FROM TB_SALE_CUST WHERE STATUS_CD = '07' AND SALE_DT