Display the the result of a substraction in a MySQL query (1 table)
I'd try this :


SELECT ROUND(b.price - a.price, 2) AS Returned 
FROM stop a,(select price from stop  where cityName = 'B') as b
WHERE a.cityName = 'A' AND a.`routeNo ` = '1'; 



  OR even this :


SELECT ROUND(b.price - a.price, 2) AS Returned 
FROM stop as a join stop as b 
ON a.cityName = 'A' AND b.cityName = 'B' 
WHERE a.routeNo = 'x';



  (Updated)