SQL Inner Join 3 tables

Question

Good afternoon. I want to make an Internet but the result does not come out.

Tabela1 = rec  Campo = chvbfj(3)      <- codigo do cliente
Tabela1 = rec  Campo = doc(3,4,5)     <- lista de codigos de itens do cliente
Tabela2 = vndB Campo = chvvnda(3,4,5) <- tem o codigo de itens do cliente  
Tabela2 = vndB Campo = chvps(1,1,2)   <- codigo da descrição  
Tabela3 = ps   Campo = chvps(1,1,2)   <- tem o codigo da descrição  
Tabela3 = ps   Campo = Desc(escova, escola, lixa) <- descricao do codigo

Making the client’s query(3) he lists the items(1,1,2), but would have to appear the code description(brush, brush, sandpaper).

 public DataTable PesquisaResumo(global::CamadaModelos.mdlEmpresa _mdlEmpresa)
    {
        string ConexaoAccess = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\tabela.mdb";
        OleDbConnection ConexaoDB = new OleDbConnection(ConexaoAccess);
        ConexaoDB.Open();

        string Query = "SELECT rec.chvbfj, rec.doc, vndB.chvvnda, vndB.chvps, ps.chvps, ps.Dsc FROM rec INNER JOIN vndB on vndB.chvvnda = rec.doc INNER JOIN ps on ps.chvps = vndB.chvps WHERE rec.chvbfj = @id";

        OleDbCommand cmd = new OleDbCommand(Query, ConexaoDB);

        cmd.CommandType = CommandType.Text;
        OleDbParameter pmtID = cmd.CreateParameter();
        pmtID.ParameterName = "@id";
        pmtID.DbType = DbType.String;
        pmtID.Value = _mdlEmpresa.ID;
        cmd.Parameters.Add(pmtID); 

        OleDbDataAdapter da = new OleDbDataAdapter(cmd);
        DataTable empresas = new DataTable();
        da.Fill(empresas);
        ConexaoDB.Close();
        return empresas;
    }

Answer 1

select  a.chvbfj, b.chvvnda, c.Desc  from rec a
inner join vndB b on b.chvvnda = a.doc
inner join ps c on c.chvps = b.chvps
WHERE a.chvbfj = '3'

Answer 2

SELECT * FROM Table 1
INNER JOIN Table2 ON Table2 . id = Table1.id
INNER JOIN Table3 ON Table3 = Table1 . id

Answer 3

SELECT C.Desc FROM rec A
JOIN vndB B on B.chvvnda = A.doc
JOIN ps C ON C.chvps = B.chvps 

After that search the data you want with the conditions you want.