Reverting table sequence in SQL statement (RESOLVED)

Hello everybody

I`m using Crystal Reports 10 to create this report. Since I`m still experimenting I used just two tables and three fields of those tables. The SQL statement that Crystal Reports uses is :

Code:

---

SELECT `epis_mhxanhma`.`Hmeromhnia`, `epis_mhxanhma`.`Kostos`, `antallaktiko`.`Perigrafh`
 FROM  `bio_tech`.`antallaktiko` `antallaktiko` INNER JOIN `bio_tech`.`epis_mhxanhma` `epis_mhxanhma` ON `antallaktiko`.`Kwd_Episkeyhs`=`epis_mhxanhma`.`Kwd_Episkeyhs`
 ORDER BY `epis_mhxanhma`.`Hmeromhnia`

---

The problem is that I would like to have the epis_mhxanhma table selcted and the antallaktiko table inner joined. How can I tell Crystal Reports to change the order?

thx, in advance

George Papadopoulos