Where are you joining the tables? If it’s in IDT, you need generic SQL that both SQL and Oracle can use. Have a look at my post here - about half way down for some ideas: DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2
debbie
Debbie 
(BOB member since 2005-03-01)