astalavista wrote:
> Hi,
>
> How can I tanslate the query below into ANSI join:
>
> select
> t.upi,
> t.imputation,
> t.nom,
> t.prenom
> from transactions t,produits p,factures f,codesregroupementproduits
> crp,centresdecout c, imputations i
> where
> t.codeproduit = p.codeproduit(+)
> and t.comptefournisseursap = p.comptefournisseursap(+)
> and t.comptefournisseursap = f.comptefournisseursap(+)
> and t.comptenexans=f.comptenexans(+)
> and t.facture=f.facture(+)
> and p.id_code=crp.id_code(+)
> and t.imputation = c.imputation(+)
> and c.limputation = i.imputation(+)
>
> The following is OK:
>
> select t.upi,t.imputation,t.nom,t.prenom
> from transactions t
> left outer join produits p on t.codeproduit = p.codeproduit and
> t.comptefournisseursap = p.comptefournisseursap
> left outer join factures f on t.comptefournisseursap =
> f.comptefournisseursap and t.comptenexans=f.comptenexans and
> t.facture=f.facture
> left outer join centresdecout c on t.imputation = c.imputation
>
>
> How I can translate the following joins:
> p.id_code=crp.id_code(+)
> and
> and c.limputation = i.imputation(+)
>
>
>
> Thanks in advance ...
Why would you want to? But if you insist ... look in Morgan's Library
at www.psoug.org. Click on Joins.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Mar 13 2006 - 14:57:58 CST
