creating a view using two tables...

From: maylee <mayleel_at_my-deja.com>
Date: Fri, 28 Jan 2000 19:30:09 GMT
Message-ID: <86sqnp$kj8$1@nnrp1.deja.com>

I'm trying to create a view with two tables.

The first table is the main account table. The second table has a foreign key reference.

Here's an example:

TABLEA
accountnumber
name

DATA:
12345,mary smith

TABLEB
accountnumber
phone
phonetype

DATA:

12345,954-9393,1
12345,954-5554,2
12345,954-1234,3

expected view:
VIEWA:
accountnumber
name
phone1
phone2

DATA:
12345, mary smith, 954-9393, 954-5554

How can I do that?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 28 2000 - 13:30:09 CST