I have found a slightly obscure (at least to me) problem with parameterized views.

I had a view :

SELECT *,equip.eqno ;
FROM fab LEFT OUTER JOIN equip;
ON Fab.equip_id = Equip.equip_id ;
WHERE Fab.equip_id = ?equip.equip_id

The view fails showing all records not just those limited by the WHERE clause. No Error message.

The join may be fouling the where clause.

What I had to do was use a alias in either the join or the where clause.

SELECT *,equip2.eqno ;
FROM fab LEFT OUTER JOIN equip AS equip2;
ON Fab.equip_id = Equip2.equip_id ;
WHERE Fab.equip_id = ?equip.equip_id

Only other time I used an alias in a join was when I had to use the same table with different join conditions.

No question - just posted to get it into the database.