Select to join two Father and Son tables one below the other

Question

I would like to know how to get the result according to the image, I have a column with id that links the father and son records, I know that the join joins the tables side by side, however, needed to join below.

Answer 1

Use the UNION operator:

SELECT * FROM
(
    SELECT chave, Data_Venda, Qtde_Produto, Valor_Produto FROM Tabela_Pai
    UNION
    SELECT chave, Data_Venda, Qtde_Produto, Valor_Produto FROM Tabela_Filho
) temp
ORDER BY chave;