Re: can I do this in SQL??

From: KRM <malleykr_at_my-deja.com>
Date: Fri, 22 Oct 1999 15:51:49 GMT
Message-ID: <7uq16k$2nf$1@nnrp1.deja.com>

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