Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    162

    Unanswered: What is SYBASE equivalent of ORACLE "minus" function?

    I am trying to figure out if SYBASE has an equivalent of ORACLE's "minus" function. The function returns the difference in data b/w 2 identical table columns etc. It is good for inserting the differences in data b/w 2 tables to make the tables the same in terms of data

    Thanks.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i checked the online sybase docs for EXCEPT, which, i believe, is the sql standard operator, but couldn't find anything on it

    so let's do it the old fashioned way (the way we had to accomplish the same results before the new-fangled join operators)

    select whatever
    from table1 T1
    where not exists
    ( select 1
    from table2
    where id = T1.id )


    rudy

  3. #3
    Join Date
    Mar 2002
    Posts
    162
    too bad , Thanks anyways Rudy.

Posting Permissions

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