Got it Thanks every 😎 :hehe: 😉 😛 😀 🙂

select distinct t1.*,T2.* from Table_1 t1 inner

join Table_1 t2 on t1.routeno=t2.routeno

where (t1.stop='A' ) and (t2.stop='E')

and t2.stopno>t1.stopno

order by t1.routeno

select...

select distinct t1.routeno from Table_1 t1 inner

join Table_1 t2 on t2.stop=t1.stop

where

(t1.stop='D' and t1.stopno<t2.stopno)

or(t1.stop='E' and t1.stopno>t2.stopno )

problem in this query is its showing me route no 2 also...