Select distinct

a.exception_id,

a.changed_by,

b.product_code,

c.prod_name

From

ofac_exception_status_audit a,

ofac_exception_source b,

ofac_product_type c

Where

c.product_code = b.product_code

and

a.changed_by = 'Q198mb'--<ENTER REP ID>-- 

and

a.exception_id = b.exception_id 

and

b.exception_datetime between '22-Mar-2009' and '23-Mar-2009' --<ENTER DESIRED DATE>--