>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
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing