>I then coded the correct SQL statement and used the Create SQL View command to create the view in the database. Amazingly, the resulting view changed the SQL statement to the way described above (the one that doesn't work)!
>
>Does anyone understand what is going on and assist me in getting this to work?
>

You mean when coming back into the view designer, right?
Once you've coded a view that you couldn't get to work in the view designer, you can't go back to the view designer.
Get a copy of GenDBCX and use that to extract view code instead if you need to.
There are some files here on the UT - in the Files sections - that do this as well.