>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

* Set m.vp_custid = "" to select all rows: 
SELECT * ;
  from customer ;
  where ?vp_custid IN ( custid, "" )
* To