>>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
*******************************************************
Save a tree, eat a beaver.
Denis Chassé