Nandini

Nandini

  • 1.9k
  • 176
  • 4.8k

ERROR: syntax error at or near "join" Position: 3

Aug 30 2021 9:48 AM

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


Answers (3)