两个表的关联查询问题！！！

[cqandy]

table1:

name nameno
mike 001
jack 002
john 003

table2:

time addr tel nameno
2002-12-01 china 12345678 002
2001-11-01 japan 87654321 001


希望写一个语句
得到如下的结果：

2002-12-01 china 12345678 jack
2002-11-01 japan 87654321 mike

[spland]

高手能提示一下，为什么要用 left ,inner join 不是就可以了吗？
请教！

[darkmoon]

如果table2有一条记录如下，nameno在table1中没记录用left也能查出来，结果是以table2的查询结果为基准的
time addr tel nameno
2002-12-01 china 12345678 005

[CrazyFor]

select bb.time,bb.addr,bb.tel,aa.name from table2 bb left outer join table1 aa on bb.nameno=bb.nameno

[Chiff]

select a.time,a.addr,a.tel,b.name
from table2 a,table1 b
where a.nameno = b.nameno

[CrazyFor]

select bb.time,bb.addr,bb.tel,aa.name from table2 bb left outer join table1 aa on bb.nameno=bb.nameno

[kk_wyx]

select table2 .time,table2 .addr,table2 .tel,table1.name
from table2
join table1 on table2.nameno = table1.nameno

[大米团]

select bb.time,bb.addr,bb.tel,aa.name from table2 bb left outer join table1 aa on bb.nameno=bb.nameno

[愉快的登山者]

select A.time ,A.addr,A.el, B.name from table2 as A
left join table1 as B on A.nameno = B.nanmeno