whats the query?
"gil guerillot" <gil.guerillot_at_ratp.fr> wrote in message
news:9s68nr$34t$1_at_gotix.reseau.ratp...
> My query is a little different:
>
> the 2 conditions are on the same field but not yours!!
>
>
>
> Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> a écrit dans le
> message : 3be69341$0$8511$ed9e5944_at_reading.news.pipex.net...
> > Yes you can certainly write in this format for example
> >
> > select num_rows from dba_tables
> > where table_name in (select table_name from user_tables where
> last_analyzed
> > is not null)
> > or owner = 'SYSTEM'
> >
> > which returns results on my system when run as a user with dba privs.
> >
> > perehaps you could post your actual sql and any error messages.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission Uk
> >
> > "gil guerillot" <gil.guerillot_at_ratp.fr> wrote in message
> > news:9s5sc4$2q4$1_at_gotix.reseau.ratp...
> > > I have a SQL query like this:
> > >
> > >
> > > Select *
> > > from table1
> > > where condition1 in(select field1 from table2
> > > where condition2=parameter1)
> > > or condition1 like parameter2
> > >
> > >
> > > Is it possible like this ?
> > > result never appear
> > >
> > >
> > >
> >
> >
>
>
Received on Mon Nov 05 2001 - 08:53:12 CST
