Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: can I do this in SQL??
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>;
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 - 10:51:49 CDT