View with mixed fields

From: Gregor Horvath <g.horvath_at_gmx.at>
Date: Thu, 25 Mar 2004 21:05:53 GMT
Message-ID: <RQH8c.240846$Or1.163922@news.chello.at>

Hello,

I have two tables:

Table A:

Field 1

---

1
2
4
5
7

Table B:

Field 1 Field 2

---

1		3
2		6
5		8

I want to create a view which mixes the values of tableA.Field1 and tableB.Field2 into one field 3 of the result view.

result view:

Field3

---

1		(from tableA.Field1)
2		(from tableA.Field1)
3		(from tableB.Field2)
4		(from tableA.Field1)
5		(from tableA.Field1)
6		(from tableB.Field2)
7		(from tableA.Field1)
8		(from tableB.Field2)

Is this possible?
How?

Greg Received on Thu Mar 25 2004 - 15:05:53 CST