Select multiple Mysql

0

I need to fetch data from a table and complete it with data from another table ...

Main table: agendatelefone Secondary table: neighborhood

principal: 
    [{"id":1,"tipo":"delivery","nome":"aaa","telefone":983585042,"endereco":"26 de outubro","logodouro":"av","numero":1965,"complemento":101,"bairro":"bela vista","senha":"dsadas","obs":"","pdtotal":0},{"id":2,"tipo":"delivery","nome":"aaa","telefone":999994242,"endereco":"26 de outubro","logodouro":"av","numero":1965,"complemento":101,"bairro":"horto","senha":"dsadas","obs":"","pdtotal":0}]


secundaria: 
    [{"id":1,"nome":"bela vista","valor":3},{"id":2,"nome":"horto","valor":6},{"id":3,"nome":"Centro","valor":1}]

I would like to send the value field to the main table that corresponds to each neighborhood ...

    
asked by anonymous 09.03.2016 / 19:11

1 answer

0

Solution

SELECT * FROM agendatelefone bro INNER JOIN bairro usr ON (bro.bairro = usr.nome)
    
09.03.2016 / 19:51