Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question for SQL master
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