[T_TIME_IN] TIME NOT NULL

select a.T_TABNUMBER, a.T_FIO, a.T_DATE, a.T_TIME_IN, 
       b.T_DATE, b.T_TIME_OUT, a.T_ORGUNIT, a.T_CARD_SN, a.T_JOBSTATE
from (select * from JURNAL where T_IN_OUT='вход') a 
   left join (select * from JURNAL where T_IN_OUT='выход') b 
   on (a.T_TABNUMBER=b.T_TABNUMBER and a.T_DATE=b.T_DATE)

select count(*) from JURNAL where T_IN_OUT='вход';

select distinct a.*
from JURNAL a join JURNAL b
  on a.T_TABNUMBER=b.T_TABNUMBER and a.T_DATE=b.T_DATE 
     and a.T_IN_OUT=b.T_IN_OUT and (a.T_TIME_IN<b.TIME_IN or a.TIME_OUT<b.TIME_OUT);

select distinct a.*
from JURNAL a join JURNAL b
  on a.T_TABNUMBER=b.T_TABNUMBER and a.T_DATE=b.T_DATE 
     and a.T_IN_OUT=b.T_IN_OUT and (a.T_TIME_IN<b.TIME_IN or a.TIME_OUT<b.TIME_OUT);

and a.T_IN_OUT=b.T_IN_OUT and (a.T_TIME_IN<b.TIME_IN or a.T_TIME_OUT<b.T_TIME_OUT);

select distinct a.*
from JURNAL a join JURNAL b
  on a.T_TABNUMBER=b.T_TABNUMBER and a.T_DATE=b.T_DATE 
     and a.T_IN_OUT=b.T_IN_OUT 
     and (a.T_TIME_IN<b.T_TIME_IN or a.T_TIME_OUT<b.T_TIME_OUT);