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

Question

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        A4select a.column3,a.column2(进入),b.column2(退出) from 
(select * from table where column1 ='进入') a
,(select * from table where column1 ='退出') b
where a.column3=b.column3

Answer 1

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

Answer 2

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