Select with field of the same name between two tables without connection however approximate values

Question

I have the 3 tables, 'users_teste', 'nps' and 'product', the product table has no relation with the other 2 tables, I need to perform a search comparing the request of the table 'nps' with the request of the table 'product' to count how many products the user has and show in the name of such product.

The problem found is that in the request field of table 'nps' has the following value '523dsagtjhtz' and the request field of table 'product' has the value '523dsagtjhtz V-Gabriel' since the start is equal and it is possible to cross and perform the desired select???

        CREATE TABLE users_teste (
              id int(11) NOT NULL AUTO_INCREMENT unique,
              username varchar(50) NOT NULL,
              cpf varchar(11) NOT NULL unique,
              permission varchar(20) NOT NULL,
              email varchar(200) NOT NULL unique,
              password varchar(200) NOT NULL,
              passwordResetToken varchar(200),
              resetarSenha varchar(200),
              dataCriacao datetime,
              idusuario varchar(200) not null,
              PRIMARY KEY (cpf)
            ) ;
        
        CREATE TABLE nps (
            id_nps integer auto_increment unique,
            solicitacao varchar(20) not null unique,
            notaNps integer,
            comentarioNps varchar(600),
            horaEnvioPesquisa datetime,
            horaRespostaPesquisa datetime,
            statusPesquisa varchar(5) default='0',
            telefone varchar(20) not null,
            nps_users_iden varchar(14) not null,
            primary key(solicitacao,telefone),
            foreign key(nps_users_iden) references users_nps(cpf)
        );
        
        create table produto(
        id_produto_increment integer not null auto_increment unique,
        dataSituacao datetime,
        status varchar(200) not null,
        recusas integer not null,
        id varchar(100) not null ,
        email varchar(200) not null,
        solicitacao varchar(100) not null,
        idproduto integer not null,
        titular varchar(200) not null,
        dataAprovacao datetime not null,
        situacao varchar(100) not null,
        validade datetime,
        nomeProduto varchar(100) not null,
        atendimentoExterno integer not null,
        produto_colaborador integer not null,
        primary key(id,status),
        foreign key(produto_colaborador) references colaborador(idusuario)
        );



 create table colaborador(
    id_colaborador_increment integer not null auto_increment unique,
    idusuario integer not null,
    usuario varchar(200) not null,
    colaborador_unidade integer,
    primary key(idusuario),
    foreign key(colaborador_unidade) references unidade(unidadeExt)
    );