On 4/11/14, Chris Curvey <chris@xxxxxxxxxxxxxxx> wrote: > On Fri, Apr 11, 2014 at 1:50 PM, Susan Cassidy < > susan.cassidy@xxxxxxxxxxxxxxxxxxxxxxxx> wrote: > >> I have a query with several joins, where I am searching for specific data >> in certain columns. Have you tried running each of your joins separately to see if there are row values common to both tables, ie: select count(*) from scenes s left outer join scene_thing_instances si on s.scene_id = si.scene_id then select count(*) from scene_thing_instances si left outer join scene_things st on si.scene_thing_id = st.scene_thing_id etc. I find when building complex queries (I've written some that ran over 100 lines and involved a dozen or more joined tables), I need to build them up, testing them as I build. -- Mike Nolan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
