Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select rct.initial_date, rop.activation_time, rct.end_date, rt.tariff_name
- from ro_product as rp
- join ro_contract_tariff as rct on rct.contract_id = rp.contract_id
- join ro_ofd_pin as rop on rop.contract_tariff_id = rct.contract_tariff_id
- join ro_tariff as rt on rt.tariff_id = rct.tariff_id
- where rp.product_type_id = 20
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement