Re: Question for SQL master

Is this what you are looking for?

CREATE VIEW a_and_b AS
SELECT a.id, a.name_1, a.name_2, b.name_b1 FROM a, b
WHERE a.id = b.b_id

HTH,
Tom Best

<zyman_at_my-deja.com> wrote in message news:8kvili$4ah$1_at_nnrp1.deja.com...
> 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.
Received on Mon Jul 17 2000 - 00:00:00 CDT