Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    14

    Unanswered: Joining on Nulls

    Hi,

    Are there any configurable options in Sybase that specifies how joins on null columns are handled?

    I have inherited a query that inserts data into a #table which then does a join in which one side is null, and the other side has data.

    The query used to work, but now it doesn't... I'm sure that the null join is the dodgy part, but i'm trying to work out how it used to work???

    thanks

  2. #2
    Join Date
    Mar 2003
    Location
    Indiana, USA
    Posts
    100
    I don't known about Sybase but MS SQL uses

    SET ANSI_NULLS OFF
    or
    SET ANSI_NULLS ON

    Tim S

Posting Permissions

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