>>>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.
>
>I will look at that. Thx

Don't place conditions on second tables (from the right part) in the WHERE condition because it would make the LEFT JOIN become INNER JOIN.