Oracle在关联表的时候筛选应注意的地方

iteye_9716

于 2010-11-25 16:15:11 发布

阅读量213

点赞数

CC 4.0 BY-SA版权

分类专栏： DB &ＳＱＬ文章标签： Oracle SQL F#

本文链接：https://blog.youkuaiyun.com/iteye_9716/article/details/81965738

DB &ＳＱＬ专栏收录该内容

31 篇文章

订阅专栏

create table t AS
 (SELECT 1 id, 'y' n
    FROM dual
  UNION ALL
  SELECT 2 id, 'n' n
    FROM dual
  UNION ALL
  SELECT 3 id, 'n' n
    FROM dual
  UNION ALL
  SELECT 4 id, 'y' n FROM dual);

create table b AS
 (SELECT 1 id, 'f' n
    FROM dual
  UNION ALL
  SELECT 2 id, 'y' n
    FROM dual
  UNION ALL
  SELECT 3 id, 'n' n FROM dual);

生成t,b表，并且插入几条数据

[img]http://dl.iteye.com/upload/attachment/353627/0666d4ed-414a-3dc6-9e7d-59d1ccbd7683.jpg[/img]

[img]http://dl.iteye.com/upload/attachment/353629/a073f28c-7250-3cbb-8ea0-9d7215626529.jpg[/img]

[img]http://dl.iteye.com/upload/attachment/353633/65c2a841-4d81-32ed-a548-20c316d27636.jpg[/img]

[img]http://dl.iteye.com/upload/attachment/353638/0a56813d-6492-3102-b60c-b79ca2644df6.jpg[/img]

这就是执行结果，具体分析，我就不分析了，还没这个能力