>Hi Erik,
>first time ever eView let me down and I figured it was my SELECT statement. But this puppy runs just fine to generate a cursor or programmatically CREATE SQL VIEW AS... Yet when I paste my SQL statement (less line continuations as shown below) into eView it tells me:
>
>"eView cannot use the SQL below to redefine the view because the SQL is invalid"
>
>I figure it either doesn't like multiple UNIONs, or like it's maker it doesnt like views based on views (duck) which is BTW unavoidable here unfortunately. Any thoughts? Mucho TIA!
>
Now that was some join!
I'm doing likewise in joins off of views but not to this level. eView does'nt like them either.
And while we have Eric's attention, how about losing the showplan off the first page. It makes the form too darn big to hit the bottom buttons in my environment. 15" monitor @ 800 x 600.
__Stephen