>Edward,
>
>View Designer only lets me view the SQL code. How can I edit it or insert my own SQL statement?
>
>Thanks

You can do it programmatically using CREATE SQL VIEW.
BTW, it's really burdensome to grab so many fields into a view, i guess you could eliminate most of them.