>Hi, Kendall
>
>Yes, you've run into a serious limitation (not a bug) of the VD. The problem stems primarily from the fact that the VD insists on using the "nested" join syntax:
>
>JOIN table1 ;
> JOIN table2 ;
> JOIN table3 ;
> ON expression ;
> ON expression ;
>ON expression
>
>which makes the type of view/query you're trying to do *very* difficult, even programmatically. Better, more intuitive and just as ANSI '92 SQL compliant is the sequential syntax:
>
>JOIN table1 ON expression
> JOIN table2 ;
> ON expression ;
> JOIN table3 ;
> ON expression
>
>The solution?
>
The solution for me today is as you have listed above (nested vs. sequential joins). I don't understand it precisely, however I am grateful.
Thanks Steve.
Kendall
Kendall Webb
Senior Software Engineer
MCAD.Net/MCSD.Net