Announcement

Collapse
No announcement yet.

Sybase db query question

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Sybase db query question

    I'm using Adaptive Server Anywhere Version 9.0 and running into a problem which only happens in this version.

    I have a query with union. Each block of the query works fine with out the union until I join them using the union. The value on entered_value column is set to zero with union. Without union the column value is non zero. This same query works fine in v7 database. Any help that you can be provide would be appreciated.

    Thanks


    select

    entered_value from

    v_test where

    parent_id is not null

    union

    select

    entered_value from

    v_test where

    parent_id is null

    #2
    Installing the latest patch and upgrading db server to 9.0.1 fixed the problem.

    Comment

    Working...
    X