JOINS !

From: Oscar <oscar_at_j.com>
Date: Mon, 17 Mar 2003 18:24:58 +0100
Message-ID: <b55077$3e2$1@nsnmrro2-gest.nuria.telefonica-data.net>

Someone knows if the equivalent to this sentence in SQLSERVER ....

create view oscar as select

   A.GERIDENTI,
   A.STATDT,
   A.FEVEDT,
   A.TAUXDT,
   A.CAUXDT,
   A.CCIADT,
   A.TIPLDT,
   A.CUENDT,
   A.CLDODT,
   A.NDOCDT,
   A.SAPRDT,
   A.TICODT,
   A.NUCODT,
   A.SIMIDT,
   A.G3NCDT,
   B.STAT32,
   B.FEVE32,
   C.CCIAMG

from
(
  ( A LEFT JOIN C ON
         A.CCIADT = C.CCIAMG
  ) LEFT JOIN B ON
         A.SLMLDT = B.SLML32
)where

    isnull(A.STATDT, ' ') = 'E' and

   isnull(A.TAUXDT, '  ') <> '  ' and
   isnull(A.FEVEDT, 0) <> 0 and
   isnull(A.G3NCDT, ' ') <> '2' and
   isnull(B.STAT32, ' ') <> '2' and
   isnull(C.CCIAMG, '  ') <> '  '

is this ONE on ORACEL ?

create view oscar as select

   A.ID_A as ID_QTSERVIDOR1_GLB03AJ,
   A.STATDT,
   A.FEVEDT,
   A.TAUXDT,
   A.CAUXDT,
   A.CCIADT,
   A.TIPLDT,
   A.CUENDT,
   A.CLDODT,
   A.NDOCDT,
   A.SAPRDT,
   A.TICODT,
   A.NUCODT,
   A.SIMIDT,
   A.G3NCDT,
   B.STAT32,
   B.FEVE32,
   C.CCIAMG

 from A, C, B where ( A.CCIADT = C.CCIAMG(+)  and A.SLMLDT = B.SLML32(+) )
and A.STATDT(+) = 'E' and

   A.TAUXDT(+) <> '  ' and
   A.FEVEDT(+) <> 0 and
   A.G3NCDT(+) <> '2' and
   B.STAT32(+) <> '2' and

   QTSERVIDOR1_GLM01.CCIAMG(+) <> ' '

;

With ORACLE i have a problem !: the information I got on the VIEW is for all the CCIADT from A not for only the ones i have on CCIAMG from C Received on Mon Mar 17 2003 - 11:24:58 CST