>Hi All
>
>I used the view designer to create the following SQL statement.
>
>Any idea's?
>
unfortunetly the View Designer is very limited in its capabilities for creating SQL views
I don't use it except for creating very basic views
the best option usually is to start with the VD then copy the SQL code into a PRG and continue from there

Arnon