Questions tagged as 'union-all'

I am developing cash flow from my company and am encountering a difficulty. I have two different tables. A table is tb_compras(id, fornecedor, nfe, valor, data) and then I have another table tb_compras_historico_pagamentos(id, id_co...

I made a query with two selects using union and it has two columns: MOBI and DESMOBI . I need the result to show these two columns. when I execute it only shows the MOBI 'column. Below is the query. I look forwa...