SELECT *,(SELECT `fiyat` FROM `tablo1` WHERE `kur`=`kuradi` LIMIT 1)*`deger` AS `fastfiyat` FROM `tablo2` ORDER BY `fastfiyat` DESC