>I do a select sql based on a condition for a certain field and it works ok
>
>I do a big select with many joins and at the end of that select I add where. That where is based on the first condition that worked (when used alone) and nothing comes out of that query.
>
>Anyone could help me on that?

Are you using INNER JOINs? You probably need LEFT OUTER JOINs.