gistfile1.txt

Problematic Query (Auto-generated):
SELECT * FROM "proj_job" WHERE NOT ("proj_job"."customer_id" IN (SELECT U2."customer_id" AS Col1 FROM "proj_voucher" U2 WHERE (U2."merchant" = 'extra-hours' AND U2."customer_id" IS NOT NULL)) AND "proj_job"."customer_id" IS NOT NULL AND (("proj_job"."customer_id" IN (SELECT U1."id" AS Col1 FROM "proj_customer" U1 LEFT OUTER JOIN "proj_voucher" U2 ON ( U1."id" = U2."customer_id" ) WHERE (U2."job_id" IS NULL AND U1."id" = ("proj_customer"."id"))) AND "proj_job"."customer_id" IS NOT NULL) OR "proj_job"."customer_id" IS NULL));

Error:
invalid reference to FROM-clause entry for table "proj_customer"
LINE 1: ...r_id" ) WHERE (U2."job_id" IS NULL AND U1."id" = ("proj...                                                        ^
HINT:  Perhaps you meant to reference the table alias "u1".


Working Query:
SELECT * FROM "proj_job" WHERE NOT ("proj_job"."customer_id" IN (SELECT U2."customer_id" AS Col1 FROM "proj_voucher" U2 WHERE (U2."merchant" = 'extra-hours' AND U2."customer_id" IS NOT NULL)) AND "proj_job"."customer_id" IS NOT NULL AND (("proj_job"."customer_id" IN (SELECT U1."id" AS Col1 FROM "proj_customer" U1 LEFT OUTER JOIN "proj_voucher" U2 ON ( U1."id" = U2."customer_id" ) WHERE U2."job_id" IS NULL) AND "proj_job"."customer_id" IS NOT NULL) OR "proj_job"."customer_id" IS NULL));

Diff: Deleted -- AND U1."id" = ("proj_customer"."id"))