Oops. I meant to put something in this message!

I don't know how to do it in the view designer. I usually create views programatically.

>Hi Josh,
>
>One more question regarding this. When I try to put an 'OR' clause for my view in the view designer, it puts for the whole table.
>
>ie
>
>SELECT *;
> FROM STARS.REQUEST Request;
> WHERE a = ?valuea;
> AND b = ?valueb;
> AND c = ?valuec
> OR c is null;
>
>I want it to be
>
>SELECT *;
> FROM STARS.REQUEST Request;
> WHERE a = ?valuea;
> AND b = ?valueb;
> AND (c = ?valuec or c is null);
>
>How can I create the view like this in the view designer?. I know that you can get around this problem by creating the view programmatically.
>
>Thank You