Клиент Курс Контейнер Стоимость

SELECT
  cn.client_id,
  NVL(cn.sub_id,-1)   AS account_id,
  cn.container_id,
  TRUNC(cn.send_date) AS send_date,
  cn.container_cost
FROM
  container cn,
  client_sub cs
WHERE cn.status_id = 70
  AND cn.sub_id = cs.sub_id (+)
  AND cn.client_id = 1231586