Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
Column not found;-4005 POS(668) Unknown column name:S_ANCHOR
Why this error, when execute query?????
How can I fix this problem?
Declare c cursor for
With recursive px (A_ANNOTATIONID, S_ANCHOR, E_ANCHOR, found) as
(
select A.annotationid, A.start, A.end, decode (A.VALUE, 'ih', 'YES', 'NO')
From (select annotation.annotationid, start, end, value
from annotation inner join feauture on
annotation.annotationid=feauture.annotationid
where feauture.value='hv' and type='phn') AS A,
(select annotation.annotationid, start, end
from annotation inner join feauture on
annotation.annotationid=feauture.annotationid
where feauture.value='dcl' and type='phn') AS B
where A.end=B.start
union all
select annotation.annotationid, s_anchor, end, decode (VALUE,
'ih', 'YES', 'NO')
from px, annotation inner join feauture on
annotation.annotationid=feauture.annotationid
where e_anchor = annotation.start
and type='phn' and annotation.start <= (select start from annotation inner
join feauture on annotation.annotationid=feauture.annotationid where
value='dcl')
)
select annotation.annotationid, found
from annotation inner join px on annotation.annotationid=a_annotationid
inner join feauture on annotation.annotationid=feauture.annotationid
many thanks,
Francesco
How can I fix this problem?
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Hai dei virus sul tuo PC ma non sai come eliminarli? Allora impara subito
come rimuovere ogni tipo di virus - clicca qui
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=3211&d=20060223
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
