what is wrong with
select count(*) from table1
where exists(
select 1 from table2 where table2.id=1);
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Andre Grosse" <ag17_at_inf.tu-dresden.de> wrote in message
news:3C4354AE.7020108_at_inf.tu-dresden.de...
> Keith Boulton wrote:
>
> > "Andre Grosse" <ag17_at_inf.tu-dresden.de> wrote in message
> > news:3C431BBC.9070302_at_inf.tu-dresden.de...
> >
> >
> >>select count(*) from table1 left join table2 on table2.id=1;
> >>
> >
> > Not sure what you're trying to get.
> >
> > You are not actually joining table 1 and table 2.
> >
> >
>
>
> yes, thats a constructed example. but it should be possible.
>
>
> >>i get also some internal errors (a lot of crash-logs) ORA-03113 with
> >>further conditions in selects with above left joins. so there seems to
> >>be something wrong in oracle?!
> >>
> >
> > Support for this syntax is new (I think in 9i). You need to wait a few
years
> > for Oracle users to debug it, like any other new feature or use the
oracle
> > syntax.
> >
>
>
> ok, here in oracle-style-syntax:
>
> select count(*) from table1,table2 where table2.id(+)=1;
>
> same problem as above...
>
> --
> Andre Grosse
>
Received on Tue Jan 15 2002 - 03:56:17 CST
