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 :
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?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`
thx, in advance
George Papadopoulos




Reply With Quote