thank you, this worked like a charm. I appreciate your help

could you possibly use a subquery? where your join condition would look like: inner join (select distinct f1,f2,f3... from secondTable) t2 on fact.rowid=t2.rowid

Thank you, this is a great start. But, this gives me a date range that spans 7 days ago through today. What i'm aiming for is to get the "date range that spans last week (from Sunday through Saturday) regardless of when its run in the week." I think that's where i'm getting confused. So, the pseudo code would be. WHERE…