看看这个查询语句怎么写？

[PI_2002]

我有两个表T_MAN,T_INFO。结构如下
T_MAN{name char(10),
tel char(13), --电话
add char(50) --住址
}

T_INFO{id char(12), --无重复的序号
tel char(13)， --电话
long datetime，--通话长度
xm char(10), --通话人姓名
context varchar(100), --通话简要内容

现在我需要在给定 T_INFO.id 的情况下，通过一条查询语句生成如下结构的视图：
t_info.id,
t_info.tel,
t_man.name,
t_man.add,
t_info.long,
t_info.xm,
t_info.context

唯一知道的条件就是 t_info.id = '给定值'

[zw_sjj]

select t_info.id,t_info.tel,t_man.name,t_man.add,t_info.long,t_info,xm,t_info.context from t_info,t_man where t_info.id='给定值' and t_info.tel=t_man.tel

[j9988]

select
t_info.id,
t_info.tel,
t_man.name,
t_man.add,
t_info.long,
t_info.xm,
t_info.context
from t_man,t_info
where t_man.tel=t_info.tel
and t_info.id = '给定值'

[willyzeng]

select t_info.id,
t_info.tel,
t_man.name,
t_man.add,
t_info.long,
t_info.xm,
t_info.context from t_info,t_man
where t_info.tel = t_man.tel and t_info.id = '给定值'

[superdev]

select t_info.id,
t_info.tel,
t_man.name,
t_man.add,
t_info.long,
t_info.xm,
t_info.context
from t_info,t_man
where t_info.id=给定值
and t_info.tel = t_man.tel