如何生成这样的表格式呢?

[superfishmanweb]

原始表的记录项
column1 column2(操作时间) column3
--------------------------------------------------
进入 06-05-06 12:12:12 A1
退出 06-05-06 13:12:12 A1
进入 06-05-06 14:12:12 A2
进入 06-05-06 15:12:12 A4


我要利用上表的原始条件生成下面的报表,应该如何做呢?
column1 column2(进入时间) column3(退出时间)
--------------------------------------------------
A1 06-05-06 12:12:12 06-05-06 13:12:12
A2 06-05-06 14:12:12 06-05-06 14:12:12

[superfishmanweb]

up

[superfishmanweb]

up

[superfishmanweb]

up

[北极海hein]

column1 column2(操作时间) column3
--------------------------------------------------
进入 06-05-06 12:12:12 A1
退出 06-05-06 13:12:12 A1
进入 06-05-06 14:12:12 A2
进入 06-05-06 15:12:12 A4

select a.column3,a.column2(进入),b.column2(退出) from
(select * from table where column1 ='进入') a
,(select * from table where column1 ='退出') b
where a.column3=b.column3

[superfishmanweb]

如果有n多条A1或Ax的话,应该配不成对,怎么解决

[爱思考的磐石]

column1 column2(操作时间) column3
--------------------------------------------------
进入 06-05-06 12:12:12 A1
退出 06-05-06 13:12:12 A1
进入 06-05-06 14:12:12 A2
进入 06-05-06 15:12:12 A4


select a.column3,a.column2 进入,b.column2 退出 from
(select * from lytest where column1 ='进入') a
,(select * from lytest where column1 ='退出') b
where a.column3=b.column3(+)
Union
select b.column3,a.column2 进入,b.column2 退出 from
(select * from lytest where column1 ='进入') a
,(select * from lytest where column1 ='退出') b
where a.column3(+)=b.column3