Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: For only ORACLE Guru

Re: For only ORACLE Guru

From: Epicentre team A <oracle_at_epicentre.fr>
Date: Thu, 4 Jul 2002 13:04:56 +0200
Message-ID: <ag19v4$ps7$1@wanadoo.fr>


RIGHT JOIN is not correct try with +

Sample:

SELECT .... FROM A, B .... WHERE A.ID = B.ID + "supporto" <supporto_at_tamautomazione.com> wrote in message news:GzVU8.33475$Jj7.882650_at_news1.tin.it...
> Dear friends, from my client with ADO + oracle driver ODBC 8i (v.8.1.77)
> when I try to execute a SQL Statement I alway receive the message
>
> -2147217900 [Oracle][ODBC]Syntax error or access violation.
>
> When I Delete from query table CentriCo (is better if you see the image in
> attach) I didn't error
>
> Can anyone help me?
>
> select count(*) from {oj Contatori RIGHT JOIN (Ubicazio RIGHT JOIN
> (TipStrut RIGHT JOIN (TemplPre RIGHT JOIN ((CentriCo RIGHT JOIN Struttur
ON
> CentriCo.Id = Struttur.IdCentriCo) INNER JOIN (Richiede RIGHT JOIN
(Priorita
> RIGHT JOIN (Commesse RIGHT JOIN (CodGuast RIGHT JOIN (Storico INNER JOIN
> Attivita ON Storico.Id = Attivita.IdStorico) ON CodGuast.Id =
> Storico.IdGuasto) ON Commesse.Id = Storico.IdCommessa) ON Priorita.Id =
> Storico.IdPriorita) ON Richiede.Id = Storico.IdRichied) ON Struttur.Id =
> Attivita.IdStruttur) ON TemplPre.Id = Attivita.IdTemplPre) ON TipStrut.Id
=
> Struttur.IdTipStrut) ON Ubicazio.Id = Struttur.IdUbicazio) ON Contatori.Id
=
> TemplPre.IdContatori } WHERE Storico.F_Stato IN ( 1,2) AND
> ((Attivita.NProgr = 0)) AND ((Storico.F_TipMan = 0 And
Storico.F_TipPreve
> IN (0,3,1,2,5)) OR (Storico.F_TipMan IN (1,2)))
>
>
Received on Thu Jul 04 2002 - 06:04:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US