Re: For only ORACLE Guru

Hi

I wouldn't exactly class myself as an Oracle guru (more as a nice guy with a fondness for David Bowie music) but the right join syntax was only introduced in 9i and you're unfortunately on 8.1.7.

Listen to the advice you've been given, I think they're onto something.

Good luck

Richard
"supporto" <supporto_at_tamautomazione.com> wrote in message news:xkWU8.33670$Jj7.887075_at_news1.tin.it...
> from vb and Oracle Odbc driver if I use inner e outer join inside escape
{oj
> ............}, the driver translate the statement correctly ....
>
> I think that syntax is ok with oracle odbc driver
>
>
>
> Epicentre team A <oracle_at_epicentre.fr> wrote in message
> ag19v4$ps7$1_at_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 - 07:22:52 CDT