On 27/05/2014 16:17, jakef...@yahoo.com [firebird-support] wrote:

In general, does it make a difference whether the filter conditions are in the JOIN or WHERE clause?


In particular, if there are outer joins you can get different results.

--
Tim Ward

  • ... jakef...@yahoo.com [firebird-support]
    • ... Tim Ward t...@telensa.com [firebird-support]
    • ... Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
    • ... Ann Harrison aharri...@ibphoenix.com [firebird-support]
      • ... jakef...@yahoo.com [firebird-support]
      • ... W O sistemas2000profesio...@gmail.com [firebird-support]
        • ... Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
          • ... W O sistemas2000profesio...@gmail.com [firebird-support]
    • ... 'E. D. Epperson Jr' dixonepper...@gmail.com [firebird-support]

Reply via email to