Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-00936: missing expression
"Alexander Shuvalov" <saturn_at_hot.ee> a écrit dans le message news:
c6f073f6.0109060628.637ac967_at_posting.google.com...
> Hi, all!!!
>
> Why do I get the following error: ORA-00936: missing expression, when
> exectuing this command on Oracle 8.0.5 server? The command is: SELECT
> a.txtcode, b.txtcode FROM W76.TRANSLATION a, DUMP.TRANSLATIONTX b WHERE
> a.origtext = b.trantext AND b.langcode = 'FI' AND (SELECT COUNT(*) FROM
> DUMP.TRANSLATIONTX WHERE langcode = 'EN' AND txtcode = b.txtcode)>0. But
> the same command works fine on ORacle 8.1.6 server!!!
>
> What is the problem here?
>
> TIA
Try:
SELECT
a.txtcode, b.txtcode
FROM (SELECT txtcode, COUNT(*) cnt FROM DUMP.TRANSLATIONTX
WHERE langcode = 'EN' group by txtcode) c, W76.TRANSLATION a, DUMP.TRANSLATIONTX b WHERE a.origtext = b.trantext AND b.langcode = 'FI'AND c.txtcode = b.txtcode
-- Hope this helps MichelReceived on Thu Sep 06 2001 - 10:45:37 CDT