Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Joins under Oracle
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