SELECT RT.ROOM_SYMBOL,
RTI.ROOM_NAME,
P.OYADO_PLAN_NO,
P.PLAN_TYPE,
PI.PLAN_NAME,
P.STATUS,
MAX(GC.DAY) AS DAY
FROM
HT_GOODS G
LEFT JOIN HT_PLAN P ON G.PLAN_NO = P.PLAN_NO
INNER JOIN HT_PLAN_I18N PI ON P.PLAN_NO = PI.PLAN_NO
LEFT JOIN HT_ROOMTYPE RT ON G.ROOM_NO = RT.ROOM_NO
INNER JOIN HT_ROOMTYPE_I18N RTI ON RT.ROOM_NO = RTI.ROOM_NO
LEFT JOIN HT_GOODS_CHARGE GC ON GC.GOODS_NO = G.GOODS_NO
WHERE G.FACILITY_CODE = '50001'
AND P.DISP_FLAG = '1'
AND RT.DISP_FLAG = '1'
AND G.DELETE_FLAG = '0'
AND RTI.LANGUAGE_CODE = 'ja'
AND PI.LANGUAGE_CODE = 'ja'
GROUP BY RT.ROOM_SYMBOL,
RTI.ROOM_NAME,
P.OYADO_PLAN_NO,
P.PLAN_TYPE,
PI.PLAN_NAME,
P.STATUS,
RT.DISP_SEQ,
P.DISP_SEQ
ORDER BY RT.DISP_SEQ ASC,
P.DISP_SEQ ASC在同事的指点下第一次写了
Inner join on
left join on这样的SQL但是在
from
Inner join on
left join on
之后 这样连接表,有点不明白,他和在 wherer 之后 左右连接 有何区别?
谁能简单的说说左连接 和 右连接或者是 给点资料也可以的
RTI.ROOM_NAME,
P.OYADO_PLAN_NO,
P.PLAN_TYPE,
PI.PLAN_NAME,
P.STATUS,
MAX(GC.DAY) AS DAY
FROM
HT_GOODS G
LEFT JOIN HT_PLAN P ON G.PLAN_NO = P.PLAN_NO
INNER JOIN HT_PLAN_I18N PI ON P.PLAN_NO = PI.PLAN_NO
LEFT JOIN HT_ROOMTYPE RT ON G.ROOM_NO = RT.ROOM_NO
INNER JOIN HT_ROOMTYPE_I18N RTI ON RT.ROOM_NO = RTI.ROOM_NO
LEFT JOIN HT_GOODS_CHARGE GC ON GC.GOODS_NO = G.GOODS_NO
WHERE G.FACILITY_CODE = '50001'
AND P.DISP_FLAG = '1'
AND RT.DISP_FLAG = '1'
AND G.DELETE_FLAG = '0'
AND RTI.LANGUAGE_CODE = 'ja'
AND PI.LANGUAGE_CODE = 'ja'
GROUP BY RT.ROOM_SYMBOL,
RTI.ROOM_NAME,
P.OYADO_PLAN_NO,
P.PLAN_TYPE,
PI.PLAN_NAME,
P.STATUS,
RT.DISP_SEQ,
P.DISP_SEQ
ORDER BY RT.DISP_SEQ ASC,
P.DISP_SEQ ASC在同事的指点下第一次写了
Inner join on
left join on这样的SQL但是在
from
Inner join on
left join on
之后 这样连接表,有点不明白,他和在 wherer 之后 左右连接 有何区别?
谁能简单的说说左连接 和 右连接或者是 给点资料也可以的
解决方案 »
- 关于oracle 大数据量查询的优化方案 如果你有招 那就进来聊聊~~
- oracle em 跳转到奇怪的画面
- 数据库启动
- power designer 打开一个pdm文件怎么没数据啊
- 关于对大表进行操作的问题
- c#连接的是oracle92的数据库出现的问题!!!!!!!!!!
- 又是一个问题,备份相关问题,备份的后的文件扩展名是*.dmo.gz,大侠请关注
- 在线等,win2000 server下载安装oracle8.1.6老是不成功,救命啊
- rs/6000 aix 系统上的oracle问题,求救!
- 不用索引的问题
- oracle捕捉和跟踪
- Design and create and test two master-detail forms to do entry, query, delete and update of the following:
on等效于
from a,b
where a.id = b.id
left join 就是以左边为准:
如果
a b
id content id content
1 a 1 a
2 b
select * from a
left join b
on a.id = b.id得到
id content id content
1 a 1 a --两表都有,所以显示
2 b null null --b表没有,所以为nullright join 相反