MySQL Forums
Forum List  »  Informix

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

Hy, I have this problem.


select *
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

Written By
View Problem with joins
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.