Joins under Oracle

From: Estelle Besnier <ebesnier_at_concept.fr>
Date: Thu, 21 Jan 1999 18:36:54 +0100
Message-ID: <787s5m$j7u$1@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 - 11:36:54 CST