Thread:

From
Date:


Hi frds

Actually i have a problem, my problem is like this... i have a table A with
one column, table B with one column and table C with one column. Now i want to
create another table D which has all the three columns from table A, B,C.
Could anyone plz help me regarding this.

Thanks in advance
Dimpy

Re:

From
"D. Dante Lorenso"
Date:
dimpyg@bsil.com wrote:

>Actually i have a problem, my problem is like this... i have a table A with
>one column, table B with one column and table C with one column. Now i want to
>create another table D which has all the three columns from table A, B,C.
>Could anyone plz help me regarding this.
>
>
That's easy to do.  Hard part is interpreting what you WANT.
You need to decide how you join table A, B, and C.  Are you
wanting table D like this:

 a | b | c
---+---+---
.. | ..| ..

or like this:

d
---
a
b
c

And, if the latter, how do you decide which rows in A match rows
in B and C?

You need to provide more information to be helped properly.

Dante