REST API, RT#28181

[freeside.git] / httemplate / REST / 1.0 / rate_detail

diff --git a/httemplate/REST/1.0/rate_detail b/httemplate/REST/1.0/rate_detail
index 54e55de..6ae5031 100644 (file)
--- a/httemplate/REST/1.0/rate_detail
+++ b/httemplate/REST/1.0/rate_detail
@@ -7,7 +7,7 @@ my $extra_sql = '';
 if ( $cgi->param('countrycode') =~ /^\+?(\d+)$/ ) {
   my $countrycode = $1;
   $extra_sql = "
-    WHERE EXISTS ( SELECT 1 rate_region
+    WHERE EXISTS ( SELECT 1 FROM rate_region
                      WHERE rate_detail.dest_regionnum = rate_region.regionnum
                        AND countrycode = '$countrycode'
   ";