Re: Join ?

> But it is more complex than with JOIN. My question is:
> is JOIN supported by Oracle ? Is there an alternative ?
>

NON !, le mot réservé JOIN n'existe pas sous Oracle (dont le SQL 92 est du "entry level", alors que dans MS-Access c'est du "full level"...). Il te faudra convertir la syntaxe "full level" en "entry" pour que le parser d'Oracle ne proteste plus.

J'ai moi-même eu un gros besoin il y a quelques mois pour convertir toute une application Access (et toutes ses queries) en SQL Oracle: je cherchais un logiciel capable d'automatiser cette tâche (en entrée le string du SQL "full" => en sortie la syntaxe de la même requête en "entry level"), mais je n'en avais malheureusement trouvé aucun. J'ai tout réécrit à la main.

Seb

In article <8iqdgk$6mr$1_at_wanadoo.fr>,
  "Xavier NOPRE" <XNopre_at_netceler.com> wrote:
> Hi,
>
> > Maybe i don't really understand what you mean but
> > this syntax is general, you list all the tables in the
> > from clause and the join conditions in the where clause:
> >
> > SELECT *
> > FROM T3, T2, T1
> > WHERE T1.F1 = T2.F2
> > AND T1.F1 = T3.F3
> > AND (...);
>
> Yes, in the case of serial JOIN, but in the case of JOIN between other
 JOIN,
> it is more complex ...
>
> > Send us and exact example of what you want and we will be
> > able to answer more precisely.
>
> Yes, here is an example:
>
> SELECT DISTINCTROW BOX_1.CD_BOX
> FROM (BOX AS BOX_1 JOIN COMPO AS COMPO_1 ON BOX_1.CD_BOX =
 COMPO_1.CD_BOX)
> JOIN ((COMPO JOIN ITEM ON COMPO.CD_PATTERN_LINK = ITEM.CD_ITEM) JOIN
 BOX ON
> COMPO.CD_BOX = BOX.CD_BOX) ON COMPO_1.CD_BOX_LINK = BOX.CD_BOX
> WHERE ((COMPO.TYP_SUBTYPE=2))
>
> I have succeeds in transforming it like that:
>
> SELECT DISTINCT CD_BOX
> FROM (SELECT COMPO.CD_BOX_LINK AS CD_BOX_LINK1
> FROM BOX,COMPO
> WHERE BOX.CD_BOX=COMPO.CD_BOX),
> (SELECT CD_BOX
> FROM BOX,(SELECT COMPO.CD_BOX AS CD_BOX1
> FROM COMPO,ITEM
> WHERE COMPO.CD_PATTERN_LINK=ITEM.CD_ITEM)
> WHERE CD_BOX=CD_BOX1)
> WHERE CD_BOX_LINK1=CD_BOX;
>
> But it is more complex than with JOIN. My question is : is JOIN
 supported by
> Oracle ? Is there an alternative ?
>
> Regards, Xavier
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 30 2000 - 00:00:00 CDT