sql问题，高手请进

SQL读取两个表数据，最终效果

table1
id name in_num in_time num
001 name1 20 2006-12-10 30
002 name2 18 2006-12-10 25

table2
id name out_num out_time num
002 name2 18 2006-12-12 7
001 name1 15 2006-12-13 15

结果
id name in_num in_time out_num out_time
001 name1 20 2006-12-10 18 2006-12-12

002 name2 18 2006-12-10 15 2006-12-13

select t1.id,t1.name,t1. in_num,ti.in_time,t2.out_num,t2.out_time

from table1 as t1,table2 as t2

where t1.id=t2.id

select a.id,name,in_num,in_time,b.out_num,out_time from table1 a inner join table2 b on a.id=b.id

select table1.id,table1.name,table1.in_num,table.in_time,table2.out_num,table2.out_time frome table1,table2 where table1.id=talbe2.id order by table1.id asc