Re: Joins under Oracle

From: Torben Jeppesen <torbenkj_at_post2.tele.dk>
Date: Thu, 21 Jan 1999 20:05:59 +0100
Message-ID: <36a77b06.0@news.euroconnect.dk>

Oracle does not have an "INNER JOIN" keyword so here goes:

SELECT DISTINCT COMPTE.CODE_DEVISE, COMPTE.COMPTE_BANCAIRE, BANQUE.SIRET AS SIRET_BANQUE, GUICHET.DOMICILIATION, PAYS.LIBELLE AS PAYS_LIBELLE,TIERS.NUM_TIERS,TIERS.ADRESSE, TIERS.VILLE,TIERS.LIBELLE, TIERS.CORRESPONDANT,TIERS.CODE_POSTAL,TIERS.SIRET FROM COMPTE, BANQUE, GUICHET, PAYS, TIERS WHERE COMPTE.CODE_BANQUE = BANQUE.CODE_BANQUE

AND COMPTE.CODE_GUICHET = GUICHET.CODE_GUICHET
AND BANQUE.CODE_BANQUE = GUICHET.CODE_BANQUE
AND COMPTE.CODE_PAYS = PAYS.CODE_PAYS
AND COMPTE.CODE_TIERS = TIERS.CODE_TIERS

AND PAYS.CODE_PAYS = TIERS.CODE_PAYS; Yours Sincerely
Torben Jeppesen

Estelle Besnier wrote in message <787s5m$j7u$1_at_cweb.concept.fr>...
>How can I achieve a similar join query under Oracle without using the
>'WHERE' statement.
>
>Because the following SELECT query :
>
>
>SELECT DISTINCT COMPTE.CODE_DEVISE,COMPTE.COMPTE_BANCAIRE, BANQUE.SIRET AS
>SIRET_BANQUE,
>GUICHET.DOMICILIATION, PAYS.LIBELLE AS
>PAYS_LIBELLE,TIERS.NUM_TIERS,TIERS.ADRESSE,TIERS.VILLE,TIERS.LIBELLE,
>TIERS.CORRESPONDANT,TIERS.CODE_POSTAL,TIERS.SIRET
>FROM (((COMPTE INNER JOIN BANQUE ON COMPTE.CODE_BANQUE =
BANQUE.CODE_BANQUE)
>INNER JOIN GUICHET
>ON (COMPTE.CODE_GUICHET = GUICHET.CODE_GUICHET) AND (BANQUE.CODE_BANQUE =
>GUICHET.CODE_BANQUE))
>INNER JOIN PAYS ON COMPTE.CODE_PAYS = PAYS.CODE_PAYS) INNER JOIN TIERS ON
>(COMPTE.CODE_TIERS =
>TIERS.CODE_TIERS) AND (PAYS.CODE_PAYS = TIERS.CODE_PAYS)
>
>which runs very well under SQLServer, returns an error under Oracle.
>
>
>Thank you for your help !!!!
>
>--
>ebesnier_at_concept.fr
>
>Regards
>Estelle.
>
>
Received on Thu Jan 21 1999 - 13:05:59 CST