SELECT distinct(cl.RIID_), cl.EMAIL_ADDRESS_, bro.ITEM, bro.ACTIVITY_DATE FROM $A$ cl JOIN $B$ bro ON cl.EMAIL_ADDRESS_ = bro.EMAIL_ADDRESS_ JOIN $D$ cms ON cms.SKU = bro.ITEM WHERE cl.EMAIL_DELIVERABILITY_STATUS_ = 'D' AND cl.EMAIL_PERMISSION_STATUS_ = 'I' AND cms.BSCATEGORYNAME = 'Toys & Baby' AND (trunc(bro.ACTIVITY_DATE)) >= (Trunc(Cast(From_Tz(Cast(Sysdate As Timestamp ), 'US/Pacific') At Time Zone 'Australia/Sydney' As Date)) - 30)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)