Re: Question

Ed Prochak <edprochak_at_adelphia.net> wrote in message > > I'd have another variation on this theme. I'd like first of all to

> > I've N tables , which are all made with a field object_id and some
> > other fields in it.
> > If all was perfect, I'd have to perform this very simple query:
> > select tableA.dataA, tableB.dataB .... from tableA, tableB ... where
> > tableA.object_id=666 and tableB.object_id = tableA.object_id ... AND
> > tableA.property='boh' AND tableB.property='pippo' ....

> Have you considered an outer join?
> SELECT tableA.dataA, NVL(tableB.dataB, 'N.A.') ....
> FROM tableA, tableB ...
> WHERE tableA.object_id = 666
> AND tableB.object_id(+) = tableA.object_id ...
> AND tableA.property = 'boh'
> AND tableB.property(+) = 'pippo' ....
>
> NOTE: the key is every place the outer joined table appears, it must have the
> outer join operator (+). Otherwise it defaults to (effectively becomes) a
> normal join.
>

Thanks you very much for your help.
This helps , honestly I'd already tried it, but the problem is: what to do if tableA.property = 'boh' is not founded ? I mean, as I told you there is no table I can be sure of ... :(

> (PS FIDE.org? is that the Chess Federation? Looks like the website is down.
> Need help?)
>

Yes, FIDE is Chess Federation, but I'm not part of the organization, I'm a simple chess player :) For sure they have problems, don't think a single person (even if as helpful as you :)) can save them :)

Francesco Received on Thu Feb 27 2003 - 04:54:17 CST