Xref: alice comp.databases.oracle.marketplace:531874 comp.databases.oracle.misc:45072 comp.databases.oracle.server:71058 comp.databases.oracle.tools:34306
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!dispose.news.demon.net!demon!news.demon.co.uk!demon!seahorse.demon.co.uk!not-for-mail
From: jason <jason@seahorseNOSPAM.demon.co.uk>
Newsgroups: comp.databases.oracle.marketplace,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
Subject: Re: can I do this in SQL??
Date: Fri, 22 Oct 1999 17:14:43 +0100
Organization: Britlandish and proud of it guv'
Message-ID: <aI0QOKlfJoacslXoTI=ejxsXw2HY@4ax.com>
References: <7umovi$t98$1@diana.bcn.ttd.net> <7uq16k$2nf$1@nnrp1.deja.com>
X-Trace: news.demon.co.uk 940608946 nnrp-09:14807 NO-IDENT seahorse.demon.co.uk:158.152.72.116
X-Complaints-To: abuse@demon.net
X-Newsreader: Forte Agent 1.6/32.525
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 46

On Fri, 22 Oct 1999 15:51:49 GMT, KRM <malleykr@my-deja.com> wrote:

>I'm not entirely sure exactly how you want to execute this, but you can
>certainly use one query to select date from two tables.
>
>select index1, column1, column2, column3
>from user_indexes, user_ind_columns
>where  <your relations here>;
>

I tried that :-

select index1, column1, column2, column3
from user_indexes, user_ind_columns
where aunty mable, uncle clive, cousin jeff

But it just came back with :-

ERROR at line 2:
ORA-00920: invalid relational operator

Do I have to use blood relatives? ;)

>If this isn't what you are trying to do, you may want to provide a
>little more information.
>
>Good luck!
>
>
>In article <7umovi$t98$1@diana.bcn.ttd.net>,
>  "Jorge" <pumuky22@usa.net> wrote:
>> Hi everyone, I'm trying to do this select ....
>> I have two tables (user_indexes and user_ind_columns) and I want this
>> output:
>>
>> index1   column1 column2 column3
>> by row
>>
>> thanks
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.