Re: Referencing a view?

Thanks for all the responses!  The one from Grigoriy was particularly
interesting, I hadn't thought of that approach.

However, I came to the realization that if somebody changes their address, I
don't want it to be changed on previous orders.  So I think i'll change the
orders table to contain the actual address information and use an INSERT ...
SELECT instead.  That way I can be sure I have an accurate record of all
orders.

Thanks!
- James