S
sfei222
Unregistered / Unconfirmed
GUEST, unregistred user!
为什么我相同的查询语句在sybase数据库下可以执行,但是到oracle数据库却不能执行;
总是提示missing right parenthesis;是不是oracle不能用right outer join,
查询语句如下;
select m.* from house_msg m where id_card in(select distinct(g.id_card)
from gather g right outer join house_msg m on g.id_card=m.id_card where
m.xh<>'' and (g.addresscode like '1101%' or m.addresscode like '1101%'))
总是提示missing right parenthesis;是不是oracle不能用right outer join,
查询语句如下;
select m.* from house_msg m where id_card in(select distinct(g.id_card)
from gather g right outer join house_msg m on g.id_card=m.id_card where
m.xh<>'' and (g.addresscode like '1101%' or m.addresscode like '1101%'))