sql

select m1.allomas,m1.ora,m1.perc,m2.allomas,m2.ora,m2.perc from menetrend m1,menetrend m2 where m1.allomas='Gyor' and (m1.vonat=m2.vonat) and (m2.allomas='Sopron') and (m1.ora*60+m1.perc>=8*60) and (m1.ora*60+m1.perc<=10*60) and (m1.ora*60+m1.perc<m2.ora*60+m2.perc);