mercredi 15 juin 2016

How do I join multiple searches in just one query?

I have four searches to do, but instead of doing it separately I would like to make just one in a row. Could someone help me please? Here is the following querys:

Number1

select ATIVO,'' VENCIMENTO, QUANTIDADE ,PRECO,'' CODFAR,'' FINANCEIRO,'','','','',CLASSIFICACAO FROM srf_operacoes WHERE data = to_date ('14/06/2016', 'dd/mm/yyyy')

Number 2

select ATIVO,'' VENCIMENTO, QUANTIDADE ,PRECO,'' CODFAR,'' FINANCEIRO,'','','','',CLASSIFICACAO FROM ativos WHERE data = to_date ('14/06/2016', 'dd/mm/yyyy')

Number 3

select ATIVO,'' VENCIMENTO, QUANTIDADE ,PRECO,'' CODFAR,'' FINANCEIRO,'','','','',CLASSIFICACAO FROM srf_base WHERE data = to_date ('14/06/2016', 'dd/mm/yyyy')

Number 4

select ATIVO,'' VENCIMENTO, QUANTIDADE ,PRECO,'' CODFAR,'' FINANCEIRO,'','','','',CLASSIFICACAO FROM ativos_rf WHERE data = to_date ('14/06/2016', 'dd/mm/yyyy')

Aucun commentaire:

Enregistrer un commentaire