Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: OUTER JOINS from MS SQL Server 2005

  1. #1
    Join Date
    Nov 2007
    Posts
    3

    Default OUTER JOINS from MS SQL Server 2005

    Hi,

    Is it possible to define outer join relationship for SQL Server 2005? This SQL Server version allows only ANSI SQL92 syntax, which is LEFT OUTER JOIN, RIGHT OUTER JOIN etc..., so I'm not able to use Complex Join option.
    Complex Join works fine for ORACLE (+) outer syntax, but what can be done for MS SQL Server???

    I don't want to decrease compatibility level for the database.


    Thanks in advance for any help..

    Bartek.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    No outer joins are possible at this stage and I would like to take the opportunity to express my hopes that this will stay like that.

    For the time being, consider wrapping your outer join in a view.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.