Specify "INNER" JOIN and scrap USING() for better MySQL compatibility

When editing a node (any node) the following error message is presented:

You have an error in your SQL syntax near &#039;USING(type_name, group_name) JOIN node_field_instance fi USING(field_name, type_&#039; at line 1 query: SELECT fi.*, g.group_name FROM node_group g JOIN node_group_fields f USING(type_name, group_name) JOIN node_field_instance fi USING(field_name, type_name) ORDER BY fi.weight in <my path>/includes/database.mysql.inc on line 167.

I have tracked this down to fieldgroup_groups() in fieldgroup.module. It seems my version of MySQL does not like the following:

      $result = db_query("SELECT fi.*, g.group_name FROM {node_group} g ".
                         "JOIN {node_group_fields} f USING(type_name, group_name) ".
                         "JOIN {node_field_instance} fi USING(field_name, type_name) ".
                         "ORDER BY fi.weight");

I have seen this before - in date.module a couple of days ago. It seems that MySQL doesn't like the JOIN's (not sure why yet) looks like you have to give it an INNER or OUTER.

I am using MySQL v3.23.56.