"FROM ServiceSpaceGroups ssg, ServiceSpaces ss WHERE groupid=?";
"FROM ServiceSpaceGroups ssg, ServiceSpaces ss WHERE groupid=? AND ssg.serviceSpaceId=ss.serviceSpaceId";
    public Vector getServiceSpacesInGroup(int groupId) throws DAOException {        Connection con = null;        PreparedStatement stmt = null;        ResultSet rs = null;        Vector v = new Vector();        try {            con = ds.getConnection();            String sql = "SELECT ssg.serviceSpaceId, ss.serviceSpaceName, ss.trustLevel " +                    "FROM ServiceSpaceGroups ssg, ServiceSpaces ss WHERE groupid=?";            stmt = con.prepareStatement(sql);            stmt.setInt(1,groupId);            rs = stmt.executeQuery();            while (rs.next()) {                ServiceSpaceImpl ss = new ServiceSpaceImpl(rs.getInt("servicespaceid"),                                                           rs.getString("serviceSpaceName"),                                                           rs.getInt("trustLevel"));                v.add(ss);            }        } catch (SQLException e) {            throw new DAOException(e);        }        finally {            try { if (rs != null) rs.close(); } catch (SQLException e) { }            try { if (stmt != null) stmt.close(); } catch (SQLException e) { }            try { if (con != null) con.close(); } catch (SQLException e) { }        }        return v;    }