[B]SELECT train_no,train_name
FROM trains
WHERE train_no
IN (
SELECT s1.train_no
FROM train_schedule AS s1
INNER JOIN train_schedule AS s2
WHERE s1.stn_code = ‘JU’
AND s2.stn_code = ‘JP’
AND s1.distance < s2.distance
AND s1.train_no = s2.train_no
) ORDER BY train_no LIMIT 0 , 30[/B]
please tell what should i do to make this query execute faster…