X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2FREST%2F1.0%2Frate_detail;fp=httemplate%2FREST%2F1.0%2Frate_detail;h=6ae503190d2083f709e17e20ca917ef5f2ebc851;hp=54e55de6cd6a01f17164d2fc31a833bfff54ccba;hb=b01ee3e9d7061a1b3b4887980b0542371be9bcd8;hpb=5f8111de04a4a914c72a1642722476db4728339c

diff --git a/httemplate/REST/1.0/rate_detail b/httemplate/REST/1.0/rate_detail
index 54e55de6c..6ae503190 100644
--- 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'
   ";