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 ...