Re: SQL Errors: Where is the error?

"Lew" <lew@[EMAIL PROTECTED]
> wrote:

>If it can be re-written so as to incor****ate some independent
intermediate 
>queries, do so until each is running smoothly. Then add them back in, one
at 
>a time. You may find that you gain some speed if you don't add everything

>back in.

     I have tried that, but the biggest problems I have are with
joins.  Suddenly, a column name is no longer unique.

>Another thing I do is to put long clauses into #DEFINE's and/or macro
subs. 
>This lets me hide some of the complexity while debugging.

     I was doing that and went back to straight code as much as
possible.  Neither approach is an ideal solution, so I may bounce back
again.

[snip]

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
     I have preferences.
     You have biases.
     He/She has prejudices.