Hi question, what's wrong with this query?
delete from temp.ppn_to_insert ti
join temp.to_delete_pn ppn
on ppn.product_id=ti.product_id and ti.part_no_id=ppn.part_no_id and ppn.default_type=ti.default_type::varchar;
I'm getting syntax error
SQL Error [42601]: ERROR: syntax error at or near "join"
Position: 36