Bug 286235: Implicit joins should be replaced by explicit joins - installment A

Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=joel, a=myk

1 files changed, 4 insertions, 3 deletions

diff --git a/editcomponents.cgi b/editcomponents.cgi
index a86329d9d..9dd290db3 100755
--- a/editcomponents.cgi
+++ b/editcomponents.cgi
@@ -81,9 +81,10 @@ sub TestComponent ($$)
 
     # does the product/component combination exist?
     SendSQL("SELECT components.name
-             FROM components, products
-             WHERE products.id = components.product_id
-             AND products.name = " . SqlQuote($prod) . "
+             FROM components
+             INNER JOIN products
+                ON products.id = components.product_id
+             WHERE products.name = " . SqlQuote($prod) . "
              AND components.name = " . SqlQuote($comp));
     return FetchOneColumn();
 }