Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question for SQL master

Re: Question for SQL master

From: <zyman_at_my-deja.com>
Date: 2000/07/17
Message-ID: <8kvvqo$f2o$1@nnrp1.deja.com>#1/1

Hi, Gavin
Yes this is exactly what I was interested. Thank You. I have problems with datatypes when try to create view. and I thought that I do smth. wrong :). It's so hard to be so stupid :) ANyway thank You

In article <007a5be8.789e5703_at_usw-ex0101-006.remarq.com>,   gdas <gdas1NOgdSPAM_at_yahoo.com.invalid> wrote:
> zyman_at_my-deja.com wrote:
> >hello,
> >I have 2 tables:
> >a (id,name, name_1, name_2)
> >and table
> >B ( b_id, name_b1)
> >
> >I have also table
> >C ( id, name_c, name_c1, name_c2)
> >
> >The question is: Could I crete VIEW with structure like table C
 which can
> >hold dates form both table (a nad B) thank You.
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
> >
> >I don't full understand the question. Is there a join between
> tables a and b or are they completely unrelated? If so you can
> do the following:
>
> create view xxxx as select 'table a' as location, id,name,
> name_1, name_2 from a
> union
> select 'table b' as location, b_id, name_b1, 'N/A', 'N/A' from b;
>
> Not sure what you really need, but something to that affect
> might be the answer...
>
> Gavin
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 17 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US