Re: can I do this in SQL??

On Fri, 22 Oct 1999 15:51:49 GMT, KRM <malleykr_at_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_at_diana.bcn.ttd.net>,
> "Jorge" <pumuky22_at_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.
Received on Fri Oct 22 1999 - 18:14:43 CEST