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.
Subject
Views
Written By
Posted
View Problem with joins
9437
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.