SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Outter Join when using between for date ranges

cmit0227May 26 2009 — edited May 26 2009

Hi -

Can someone please tell me how I would correctly outter join the following statement:

and trunc(sysdate) between hp.hhold_profile_start_date and hp.hhold_profile_stop_date

Thanks!

This post has been answered by Frank Kulash on May 26 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 23 2009

Added on May 26 2009

7 comments

466 views