I'm becoming more involved in SQL and I am really started to feel the limitations of the view designer, which up until this point I have thought was great. Simple things like joining on two fields you can't do. What's the alternative to using the view designer? Well, coding it, obviously, but I mean as far as the data environment goes? If I have a view I can just go to the form editor, go to my data environment and pop the view in there. What do you do for views you've build yourself?

This is probably a pretty basic question, but like I said, I normally don't have to deal too much with anything but very simple views.

Michael G. Emmons
The SQL un-GURU