Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Outer join with date field?
Hello Mike.
Just write:
Select a.date1, b.date2 from test1 a, test2 b where to_char(a.date,'YYDDD') = to_char(b.date(+),'YYDDD');
Thats all !
Greez,
Angelo.
Received on Thu Feb 05 1998 - 00:00:00 CST