Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL question
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)) field3FROM table1 a, table2 b
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