>My solution has been to define my view with a macro substitution in it, which looks like this:
>

CREATE SQL VIEW MyView ;
>	AS SELECT a.Field1, b.Field2 ;
>	FROM Table1 a, Table2 b ;
>	WHERE b.PriKey = a.PriKey AND &Condition

Oops, that should have read b.PriKey = a.ForKey.

By the way, in some actual implementations I used a LEFT JOIN, not the old-fashioned join condition in the WHERE clause.

Cheers,
Rich