Solutionunvalidated
Use ON CONFLICT DO NOTHING — INSERT INTO orders (order_id, customer_id, order_date). Tension: despite using a LEFT JOIN with WHERE o.order_id IS NULL, I still get the following error. Outcome: Use NOT EXISTS Instead of LEFT JOIN.
59c25be3-243b-4527-a56d-b54f2573c23f
Use ON CONFLICT DO NOTHING — INSERT INTO orders (order_id, customer_id, order_date). Tension: despite using a LEFT JOIN with WHERE o.order_id IS NULL, I still get the following error. Outcome: Use NOT EXISTS Instead of LEFT JOIN.