What I usually do is start with "select *", get the joins and where clause down, then refine the select.