Guest User

Untitled

a guest
Jun 24th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.65 KB | None | 0 0
  1.  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