Re: select:question

Hello ,

Thank you for answering,

Another person ( see comp.databases.oracle.misc ) has noticed that the values of "demandeid" are quoted -> I'll try without quotes, it should better work

Anyway , I think either that TOADD is not really practical, I'll try to use SQL*Plus if it is installed

Good night

"Anton Buijs" <remove_aammbuijs_at_xs4all.nl> a écrit dans le message de news: 3ebd01c1$0$49100$e4fe514c_at_news.xs4all.nl...
> TOAD sometimes behaves strange.
> Try to run your queries in SQL*Plus and see if you get the expected
results.
>
> delaigue <pascal.delaigue_at_wanadoo.fr> schreef in berichtnieuws
> b9hdvi$m7n$2_at_news-reader12.wanadoo.fr...
> | Hello,
> |
> |
> | My purpose is to select the lines from the table "dossier" fulfilling
> | conditions on fields belonging to the table "demande" ( "dossierid" is a
> | primary key of table "dossier" and the couple ("dossierid", "demandeid")
> is
> | a primary key of the table "demande" )
> |
> | I've tried to run this request via an interface for oracle ( TOADD ) :
> |
> | (1)
> | select numdossier from dossier
> | where dossierid in
> | ( select dossierid from demande where demandeid between '165000000' and
> | '170000000' and originedemande = 'e-Mail' and etatdemande =
'Transférée' )
> | and it does not work, it makes TOADD run out
> | For, there really is at least one line fulfilling the three conditions
> |
> | Something particular is that the table "demande" is not in the same
> database
> | than the table "dossier", so I've tried some other things to make sure
it
> | doesn't cause troubles about jointures and sub-queries "select" :
> |
> | this request does not work ( makes TOADD run out ) :
> | select numdossier from dossier
> | where dossierid = ( select ftdossierid from demande where demandeid =
> | '165420327' )
> |
> | this request does work :
> | select MonDossier.numdossier from dossier MonDossier, demande MaDemande
> | where MonDossier.dossierid = MaDemande.dossierid and
MaDemande.demandeid
> =
> | '165420327'
> |
> | this one does work ( makes TOADD run out ) :
> | select MonDossier.numdossier from dossier MonDossier, demande MaDemande
> | where MonDossier.dossierid = MaDemande.dossierid and
MaDemande.demandeid
> | between '165420325' and '165420329'
> |
> |
> | Can anybody tell me if there is something wrong in the request (1) ?
> | Or give me a simple way to implement it differently ?
> |
> |
> |
> | Thank you by advance,
> | Pascal Delaigue
> | Good night
> |
> | P.S. : perhaps my english/american writing is not good, it's because I'm
> | french -> if there are big mistakes, please tell me, thanks
> |
> |
> |
> |
> |
> |
> |
> |
>
Received on Sat May 10 2003 - 16:25:40 CDT