sybase的外连接

shiying_423

我觉得sybase和oracle 处理left join机制应该是一样的.都遵循SQL92

12:07:12 SQL> select t1.GK_ZFPZ_ID,t3.CHECK_STATUS
12:09:19   2  from GK_ZJZFSQ_DETAIL t1 left  join GK_SQZFPZ t3
12:09:19   3  on t1.GK_ZFPZ_ID = t3.GK_ZFPZ_ID
12:09:19   4  and nvl(t3.CHECK_STATUS,'0') not in ('2','3')
12:09:20   5  /

GK_ZFPZ_ID CHEC
---------- ----
        76
         0

Elapsed: 00:00:00.00
12:09:21 SQL>
12:09:59 SQL> select t1.GK_ZFPZ_ID,t3.CHECK_STATUS
12:09:59   2  from GK_ZJZFSQ_DETAIL t1,GK_SQZFPZ t3
12:09:59   3  where t1.GK_ZFPZ_ID = t3.GK_ZFPZ_ID(+)
12:09:59   4  and nvl(t3.CHECK_STATUS(+),'0') not in ('2','3')
12:10:00   5  /

GK_ZFPZ_ID CHEC
---------- ----
         0
        76

husthxd

"and isnull(t3.CHECK_STATUS,'0') not in ('2','3')"
not
"and nvl(t3.CHECK_STATUS(+),'0') not in ('2','3')"
如果加上(+),就正如jarjar所说的,
"所有在左边表中的数据全部出现在结果集中"了.