且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何防止内部联接查询(Postgres)重复

更新时间:2023-12-02 09:24:22

一种方法是使用 distinct

SELECT distinct "formulation_batch".* 
FROM "formulation_batch" 
INNER JOIN "formulation_batch_component" 
ON "formulation_batch"."id" = "formulation_batch_component"."formulationBatch_id" 
WHERE "formulation_batch"."project_id" = 1 
    AND (("formulation_batch_component"."component_id" = 2 
        OR "formulation_batch_component"."component_id" = 1 ))