Results 1 to 1 of 1

Thread: Reverting table sequence in SQL statement (RESOLVED)

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member divined's Avatar
    Join Date
    Aug 2004
    Location
    Thessaloniki, Greece
    Posts
    447

    Resolved 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
    Last edited by divined; May 31st, 2005 at 02:13 AM.
    SteadFast!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width