I代表进O代表出
怎么把进时间和出时间分离查询出来
SELECT
T1.date AS date,
T1.stime AS stime_I,
T2.stime AS stime_O
FROM
( SELECT date, stime FROM `table_name` WHERE ioflag = "I" ) AS T1
LEFT JOIN ( SELECT date, stime FROM `table_name` WHERE ioflag = "O" ) AS T2 ON T1.date = T2.date
ORDER BY
T1.date
select * from 表 where ioflag='I'
和
select * from 表 where ioflag='O'
这样?
select "进入时间" as inputtime,* from 表 where ioflag='I'
union all
select "出去时间" as outtime,* from 表 where ioflag='O'