Advertisement
Guest User

123

a guest
Jan 24th, 2020
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. select rct.initial_date, rop.activation_time, rct.end_date, rt.tariff_name
  2. from ro_product as rp
  3. join ro_contract_tariff as rct on rct.contract_id = rp.contract_id
  4. join ro_ofd_pin as rop on rop.contract_tariff_id = rct.contract_tariff_id
  5. join ro_tariff as rt on rt.tariff_id = rct.tariff_id
  6. where rp.product_type_id = 20
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement