我把三个表进行链接查询,查出一条数据。这条数据三张原始表都没有,这是什么原因?有哪位仁兄碰到过这问题或知道这问题怎么解决啊!!!
解决方案 »
- 求11gR2安装以后,参数配置的问题,数据库采用主从架构,配好后主要面向网站应用,包括论坛、类似网上购物等。
- linux磁盘共享
- 对表中数据进行范围统计的问题,各位大侠发表下方法(尽量不用存储过程)
- PROC一个很奇怪的问题。
- 请各位高手帮小弟建个视图,在线等待!
- 如果字段A<=B那么返回0,如果字段B<A<=C,那么返回1,如果A>C那么返回2.在SELECT 语句中怎么写
- 一个简单问题,在线等……
- 菜鸟问题!!!!!帮忙看看
- 请问oracle中的实用程序SQL*Loader,从哪里可以找到,我是初学者
- c366的机器装oracle9效果怎样?内存198
- Sql:在一张表求出迟到及正常的信息
- 关于 oracle 和.NET
from (select article0_.ID as ID5_,
article0_.SPECIAL_ID as SPECIAL2_5_,
article0_.TITLE as TITLE5_,
article0_.AUTHOR as AUTHOR5_,
article0_.COPYFORM as COPYFORM5_,
article0_.EDITOR as EDITOR5_,
article0_.KEYWORD as KEYWORD5_,
article0_.HITS as HITS5_,
article0_.UPDATETIME as UPDATETIME5_,
article0_.HOT as HOT5_,
article0_.ONTOP as ONTOP5_,
article0_.ELITE as ELITE5_,
article0_.PASSED as PASSED5_,
article0_.CONTENT as CONTENT5_,
article0_.IN_CLUDEPIC as IN15_5_,
article0_.DEFAULT_PICTURE as DEFAULT16_5_,
article0_.UPLOAD_FILES as UPLOAD17_5_,
article0_.READ_LEVEL as READ18_5_,
article0_.READ_POINT as READ19_5_,
article0_.PAGINATION_TYPE as PAGINATION20_5_,
article0_.CLASS_ID as CLASS21_5_,
article0_.DELETED as DELETED5_,
article0_.SKIN_ID as SKIN23_5_,
article0_.LAYOUT_ID as LAYOUT24_5_,
article0_.STARS as STARS5_,
article0_.TITLE_FONT_COLOR as TITLE26_5_,
article0_.TITLE_FONT_TYPE as TITLE27_5_,
article0_.MAX_CHAR_PER_PAGE as MAX28_5_,
article0_.READ_LIST as READ29_5_,
article0_.READ_SCOPE as READ30_5_,
article0_.SHOW_TIME as SHOW31_5_,
article0_.STATE as STATE5_,
article0_.RELATING_CLASS_ID as RELATING33_5_,
article0_.ID as col_0_0_,
articlecla1_.CLASS_NAME as col_1_0_,
user2_.USER_NAME as col_2_0_
from TB_ARTICLE article0_,
TB_ARTICLE_CLASS articlecla1_,
TB_USER user2_
where (article0_.DELETED != '-1')
AND (article0_.PASSED = '1')
AND (article0_.EDITOR = user2_.ID)
AND (article0_.CLASS_ID = articlecla1_.ID)
AND ((article0_.CLASS_ID IN ('0', '1502058c28[183165b]-7fb2')) OR
(article0_.RELATING_CLASS_ID = '1502058c28[183165b]-7fb2'))
AND (article0_.READ_SCOPE LIKE '0')
AND (article0_.SHOW_TIME <= '2010-10-12 01:23:38')
order by article0_.ONTOP DESC, article0_.SHOW_TIME desc)
where rownum <= 20
语句中指出你的连接方式,表明以哪个表为主表查询如:
article0_.EDITOR = user2_.ID(+)