Oh yea, I know exactly what you mean. I still catch myself every now and then saying "We need to update this database...I mean table...". Good thing my coworkers do what I mean, not what I say ;-)
>Right. Speaking for myself, I've had to concentrate on not interchangably using table=view. Like when eons ago when I learned, gee, "database" <> "table" *s*.
>
>>I use views quite a lot and that's my understanding as well. That's why I questioned the disagreement with the statement 'Don't buffer the tables when using views'.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.