Guest User

Untitled

a guest
Jun 24th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.55 KB | None | 0 0
  1. SELECT area_code AS "Area Code",
  2.        in_lcr AS "LCR",
  3.        destination_desc AS "Destination",
  4.        rate AS "Rate",
  5.        currency_id AS "$",
  6.        effective AS "Effective",
  7.        expired AS "Expired",
  8.        destination ,
  9.        rate_fixed AS "Fixed",
  10.        not_decreased AS "Not Dec"
  11. FROM bts_rate,
  12.      bts_destination
  13. WHERE destination_id = destination
  14.   AND cancelled = '10000-01-01'
  15.   AND rate_id = 698
  16.   AND (expired IS NULL
  17.        OR expired > CURRENT_DATE)
  18. ORDER BY destination_desc,
  19.          area_code,
  20.          effective
Add Comment
Please, Sign In to add comment