Merge two php+mysql query tables

Question

I have two tables: bills payable and receivables. The two tables have: code, description, date, payment date, date of receipt and value.

Like I make a query to take the data of the two tables sorting by the date?

I was using the Union:

SELECT 
    codigo,
    descricao,
    dataVencimento,
    dataEntrada,
    valor
FROM
    contasReceber
WHERE
    status= "pago" 

    UNION ALL

SELECT 
    codigo,
    descricao,
    dataVencimento,
    dataSaida,
    valor
FROM
    pagamento
order by dataVencimento

But I couldn’t think of a way to differentiate the inputs of the exits. Because I need to display this data, for example:

Codigo   Descrição   Pago    Recebido
1        farmacia    20,00   -
2        aluguel     -       30,00  

How can I do it using javascript+php+mysql?

Answer 1

continue using Union, but you should create additional columns:

SELECT 
r.codigo,
r.descricao,
r.dataVencimento,
r.dataEntrada,
0 as pago,
r.valor as recebido,
'CR' as tipo
FROM
contasReceber r
WHERE
r.status= "pago" 
and r.dataVencimento between '01/08/2017' and '30/08/2017'

UNION

SELECT 
p.codigo,
p.descricao,
p.dataVencimento,
p.dataSaida,
p.valor,
0,
'PG' as tipo
FROM
pagamento p
where p.dataVencimento between '01/08/2017' and '30/08/2017'

order by dataVencimento

remembering that the column name will follow the name of the first query.