>I've got a couple parameterized views that could be reused without the parameter (for reporting purposes). Is it better to create a separate view without the parameter, or is it possible to massage the parameter somehow?
>
>Select * from customer where custid = ?vp_custid
>
>There's another view where the parameter is from a second table, how would I do that?
>
>Select * from customer inner join address on customer.addressid = address.addressid where address.country = ?vp_country
SELECT * ;
from customer ;
where ?vp_custid IN ( custid, "" )
- Andy Rice
San Diego, CA