Rick,
This brings me back to the earlier reply. The View designer is incapable of dealing with the view as you have created it. It can not handle the way you need to use () in in the where clause. Just forget ever using the VD for this view. Put that block of code in a .prg and if you ever need to alter it change the program and rerun it. Does your view give you the correct result set.
>Then I went to view desinger and checked the SQL from 'SQL Syntax' menu. It looked like this.