Re: View with mixed fields

"Gregor Horvath" <g.horvath_at_gmx.at> a écrit dans le message de news:RQH8c.240846$Or1.163922_at_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
>

select field1 from tableA union all select field2 from tableB;

Regards
Michel Cadot Received on Thu Mar 25 2004 - 15:40:39 CST