> Martin, Woody, Helen.
>
> I saw your messages; thank you. I begun this morning to play with the

select

> statement of the views where I get this error. I have 5 views and in 2 of
> them I was getting this message. What I did is change the order of table
> names in the FROM segment of the select.... and funny thing: it worked

fine

> ... the error message did not appear any more. In the example I sent you,

I

> made the change:
>
> it was:
> FROM Z_ELEMUSUARIO, Z_GRUPOUSUARIOS_V
>
> I changed it to:
> FROM Z_GRUPOUSUARIOS_V, Z_ELEMUSUARIO
>
> and worked fine. Is there an SQL rule that specifies the order of the

"from"

> in a select statement? I'm happy because now its working, but I'd like to
> know this change was the solution ...

AFAIK, there is no rule about the order of table names, only that you should
not (and can't in FB) use ambiguous fields. However, as Martijn (or someone,
I can't remember) pointed out in an earlier reply, you have the same table
named in the first implicit join and again in the LEFT OUTER join statement.
That may or may not have something to do with it.

Woody (TMW)

----------------------
"To invent, you need a good imagination and a pile of junk."
Thomas Edison