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.

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

too bad , Thanks anyways Rudy.