>Maybe I'm missing something but wouldn't six columns in the member table require 6 JOINs instead of a single one now?
>Also in my experience the assumed fixed # of columns never stays fixed. Eventually more columns creep in.
If I have those fields in there, I wouldn't need to use another table during the query. And, those ones should remain fixed. So, that's why I was wondering.