两种外连接

于 2009-10-26 13:54:52 发布 · 127 阅读

文章标签：

#SQL

数据库专栏收录该内容

21 篇文章

订阅专栏



select cpxx.cp_xh,
       cpxx.cp_zjcode,
       to_char(cpxx.real_gzrq, 'YYYY-MM-DD'),
       cpxx.ipaddress,
       cpxx.mac,
       cpxx.cp_dj,
       cpxx.CP_ID,
       cpxx.bxq,
       jxs.jxs_mc,
       jxs.jxs_lxr,
       jxs.jxs_dh,
       cpxx.cp_id,
       cpxx.BZ,
       cpxx.SB_STATE
  from gdzc_cpxx cpxx left outer join gdzc_jxs jxs
 on cpxx.cp_id = jxs.cp_id
   where  lz_id = '1011660'


   select cpxx.cp_xh,
       cpxx.cp_zjcode,
       to_char(cpxx.real_gzrq, 'YYYY-MM-DD'),
       cpxx.ipaddress,
       cpxx.mac,
       cpxx.cp_dj,
       cpxx.CP_ID,
       cpxx.bxq,
       jxs.jxs_mc,
       jxs.jxs_lxr,
       jxs.jxs_dh,
       cpxx.cp_id,
       cpxx.BZ,
       cpxx.SB_STATE
  from gdzc_cpxx cpxx , gdzc_jxs jxs
 where cpxx.cp_id = jxs.cp_id(+)
   and  lz_id = '1011660'