MySQL Forums
Forum List  »  Informix

View Problem with joins
Posted by: Marco
Date: January 19, 2006 10:18AM

Hy, I have this problem.

Informix

select *
from
outer(ref x0 ) ,en x1 ,enc x2
where (((x1.p = x0.c ) AND (x1.n = x2.n) ) AND (x2.c = x0.c ) ) ;

And in mysql, I'm doing

from enc x2, en x1 left join (ref x0)
on ((x1.p = x0.c) AND (x1.n = x2.n) AND (x2.c = x0.c)))

but this sentence give me this error:

Error Code : 1054
Unknown column 'x2.num' in 'on clause'
(10 ms taken)

How I can do this right.
Sorry, for my poor english.

Options: ReplyQuote


Subject
Views
Written By
Posted
View Problem with joins
9408
January 19, 2006 10:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.