DEV Community

Discussion on: Tricksy Little Postgres Query Planner

Collapse
 
jgaskins profile image
Jamie Gaskins

Ah, right, I completely forgot to add it to the post. It was something like this:

SELECT table1.*
FROM table1
LEFT JOIN table2 ON table1.id = table2.table1_id
WHERE (table1.table3_id = 123456 AND table1.flag)
OR (table2.table3_id = 123456 AND table1.other_flag)