Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2002
    Posts
    3

    Unanswered: Problem Order By In Left Join

    1. HOW CAN I USE " ORDER BY " IN A VIEW IN PERVASIVE DB?

    2. I HAVE AN OUTER JOIN AND I WANT TO USE "ORDER BY " IN THE SELECT CLAUSE BEFORE THE JOIN TAKES PLACE. MY PROBLEM IS THE FOLLOWING IF THE "ORDER BY " IS WRITTEN AT THE END OF THE STATEMENT LIKE IN THE SCREEN BELOW IT IS VERY SLOW

    " Select XXX,
    CCC,
    VVV,
    ad1.BBB as ADSType,
    NNN,
    MMM,
    KKK,
    LLL
    ad2.OOOas ADCountry
    from Address
    left join UDCValue ad1 on (ad1.UDCVID = 1 and ad1.UDCVLineNo = ADSTypeLineNo )
    left join UDCValue ad2 on (ad2.UDCVID = 7 and ad2.UDCVLineNo = ADCountryLineNo)
    order by Adid "

    HOW CAN I SORT MY DATA AND AFTER MAKE THE JOINS.
    Last edited by apap; 07-02-03 at 09:50.

Posting Permissions

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