mysql – selected with reference in several tables

Good afternoon I would like an orientation to do the following searches in my bank:
I have three tables: Products, Order and Stock.
I wish to list all the stock in order and in products, as indicated below:

products

measure type code
3020 | only | 3
3021 | only | 5
3022 | only | 7
3023 | only | 3  

request

requested code
3020 | 10
3021 | 20
3022 | 10
3020 | 5
3021 | 3
3022 | 5  

stock

qd code
3020 | 200
3021 | 150
3022 | 50
3023 | 120  

Select the result

measure of type of code qtdestoque qtdestoque
3020 | only | 3 | 15 | 185
3021 | only | 5 | 23 | 127
3022 | only | 7 | 15 | 35
3023 | only | 3 | 0 | 120  

What I'm trying to do:

SELECT and. *
(SELECT sum (request qd) of the request p where p.modelo = e.codigo) as qtadpedido,
(Type chosen among the products m where m.codigo = e.codigo) as type
in stock and ORDER BY ASC code;  

Could someone help me?