Partition by outer join

Select csa_mast.cconsol,

                csa_mast.tics_code,

                csa_mast.csa_id,

csa_mast.csa_type,

csa_mast.ccy,

csa_mast.collateral_curve_id,

csa_mast.check_non_std_flags

from dummy

                left outer join csa_mast partition by (csa_mast.cconsol)

on ( (did = 1 and (csa_id is null or csa_mast.csa_type = ‘LEG’))

                or

                (d.id = 2 and csa_mast.csa_type = ‘REG’)

)

Where d.id = 1

Or (d.id = 2 and csa_mast.csa_type = ‘REG’)

Regards,

Aditya.