Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL question

Re: SQL question

From: Arlette BROSSARD <abray_at_club-internet.fr>
Date: 28 Mar 1999 21:53:48 GMT
Message-ID: <01be7965$648d6b40$b8a524c3@ntdv2113>


I don't use MS SQL-Server, but if I understand what you want to do it could be :

SELECT a.field1

      ,a.field2
      ,SUM(DECODE(a.field1,b.field2,1)) field3
  FROM table1 a, table2 b
 WHERE EXISTS (SELECT NULL
                 FROM table3 c
                WHERE a.field2 = c.field1)
GROUP BY a.field1,a.field2;

abray_at_club-internet.fr

Arno van Rossum <a.van.rossum_at_mmp-obec.nl> a écrit dans l'article <36F8CC51.669167F1_at_mmp-obec.nl>...
> Hello,
>
> Recently I switched from MS SQL-server to Oracle8 but I've some troubles
> converting my stored procedures.
>
> In MS-SQLserver I use by example:
>
> SELECT 1.field1
> , 1.field2
> , (SELECT COUNT(*)
> FROM Table2 2
> WHERE 2.field2 = 1.field1) field3
> FROM Table1 1
> , Table3 3
> WHERE 1.field2 = 3.field1;
> (A.van.Rossum_at_mmp-obec.nl)
>
Received on Sun Mar 28 1999 - 15:53:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US