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
Rajanikant HawaldarPosted Aug 30, 2021, 2:08 PM
NandiniPosted Aug 30, 2021, 2:37 PM
Basem AlshabaniPosted Aug 30, 2021, 10:14 AM
delete from temp.ppn_to_insert where product_id in(
select ti.product_id 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;)
You can not use join with delete