조인으로 테이블 row 삭제하기

delete T_alias from test_table as T_alias
JOIN join_table on T_alias.c1 = join_table.c1
where 1=1
and join_table.c2 > 1
and join_table.c2 < 10
;