Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT area_code AS "Area Code",
- in_lcr AS "LCR",
- destination_desc AS "Destination",
- rate AS "Rate",
- currency_id AS "$",
- effective AS "Effective",
- expired AS "Expired",
- destination ,
- rate_fixed AS "Fixed",
- not_decreased AS "Not Dec"
- FROM bts_rate,
- bts_destination
- WHERE destination_id = destination
- AND cancelled = '10000-01-01'
- AND rate_id = 698
- AND (expired IS NULL
- OR expired > CURRENT_DATE)
- ORDER BY destination_desc,
- area_code,
- effective
Add Comment
Please, Sign In to add comment