求一個視圖的寫法？

[wenjinhe]

我現在要從兩個表A、B里面用一個視圖C調出數據，具體視圖要求是在視圖C中把這兩個表的字段全部調出來，比如：
A表
NAME OLD SEX
AAA 12 MAN
BBB 23 MAN
CCC 12 WOM
................
B表
NAME2 OLD2 SEX2
DDD 22 MAN
EEE 25 WOM
FFF 15 MAN
................
C視圖
NAME OLD SEX NAME2 OLD2 SEX2
AAA 12 MAN DDD 22 MAN
BBB 23 MAN EEE 25 WOM
CCC 12 WOM FFF 15 MAN
................
請教高手這個語句怎么寫？
謝謝~

[xeqtr1982]

create table a(NAME varchar(10),OLD int,SEX varchar(10))
insert into a select 'AAA',12,'MAN'
union all select 'BBB',23,'MAN'
union all select 'CCC',12,'WOM'

create table b(NAME2 varchar(10),OLD2 int,SEX2 varchar(10))
insert into b select 'DDD',22,'MAN'
union all select 'EEE',25,'WOM'
union all select 'FFF',15,'MAN'
go

select [id]=identity(int,1,1),* into t1 from a
select [id]=identity(int,1,1),* into t2 from b
go

create view aa
as

select NAME,OLD,SEX,NAME2,OLD2,SEX2 from t1 a,t2 b where a.ID=b.ID
go

select * from aa
go

drop view aa
drop table t1,t2,a,b

[LouisXIV]

没看出两张表有什么关联-_-