还是通不过. 我已经换了种方式解决了.但是还是奇怪为什么 select * from aa as a inner join bb as b on a.a1=b.b1 这句话却通不过呢?
如果是9i以上版本,试下把as去掉: select * from aa a inner join bb b on a.a1=b.b1
select a.a1,b.b1 from aa a join bb b on a.a2=b.b2 where rq>to_date('1996-01-01','yyyy-mm-dd') and rq<to_date('2006-06-08','yyyy-mm-dd');
select a.a1,b.b1 from aa a left join bb b on a.a2=b.b2 where rq>to_date('1996-01-01','yyyy-mm-dd') and rq<to_date('2006-06-08','yyyy-mm-dd');
或者写成: select a.a1,b.b1 from aa a left join bb b on a.a2=b.b2 where to_date(rq,'yyyy-mm-dd')>'1996-01-01' and to_date(rq,'yyyy-mm-dd')<'2006-06-08';
select a.a1,b.b1 from aa a,bb b where a.a2=b.b2 and between to_date('1996-01-01','yyyy-mm-dd') and to_date('2006-08-20','yyyy-mm-dd')谢谢楼上几位,我是这样做的.运行能通过,不知效率如何? 再问一下,此处'yyyy-mm-dd'可否换成'yy-mm-dd'或者其它格式?
select a.a1,b.b1 from aa a,bb b where a.a2=b.b2 and rq between to_date('96-01-01','yy-mm-dd') and to_date('06-08-20','yy-mm-dd');
我已经换了种方式解决了.但是还是奇怪为什么
select * from aa as a inner join bb as b on a.a1=b.b1
这句话却通不过呢?
select * from aa a inner join bb b on a.a1=b.b1
from aa a join bb b on a.a2=b.b2
where
rq>to_date('1996-01-01','yyyy-mm-dd') and rq<to_date('2006-06-08','yyyy-mm-dd');
from aa a left join bb b on a.a2=b.b2
where
rq>to_date('1996-01-01','yyyy-mm-dd') and rq<to_date('2006-06-08','yyyy-mm-dd');
select a.a1,b.b1
from aa a left join bb b on a.a2=b.b2
where
to_date(rq,'yyyy-mm-dd')>'1996-01-01' and to_date(rq,'yyyy-mm-dd')<'2006-06-08';
from aa a,bb b
where a.a2=b.b2
and between to_date('1996-01-01','yyyy-mm-dd') and to_date('2006-08-20','yyyy-mm-dd')谢谢楼上几位,我是这样做的.运行能通过,不知效率如何?
再问一下,此处'yyyy-mm-dd'可否换成'yy-mm-dd'或者其它格式?
from aa a,bb b
where a.a2=b.b2
and rq between to_date('96-01-01','yy-mm-dd') and to_date('06-08-20','yy-mm-dd');