Post reply

Rewriting with NON ANSI

  • April 23, 2012 at 4:18 am

    #267836

    abcdefghijklm

  • April 23, 2012 at 4:55 am

    #1477388

    ....

    Please note the importance of good code formatting - it making the code much easier to read.

    Also, I would classify your query as "noodles" and suggest refactoring your inner selects (subqueries) into LEFT JOIN's as all of them must return maximum single match (otherwise they wouldn't work).

    ************************************************************************

    Code is removed.

    Look's like OP is in trouble for posting the real one...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • April 23, 2012 at 5:02 am

    This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply