CROSS JOIN, UNION ALL SQL [Linux]

CROSS JOIN (Juntar ou cruzar tabelas com chaves iguais), UNION ALL (Unir em unico resultado, no exemplo abaixo uniu o cross1 e cross2)

select uf,datahora,nomepcd from pcdmet cross join gestpcd_2 where pcdmet.nomepcd=32766 and gestpcd_2.id=32766 and datahora between '1996-03-11 00:00:00' and '1996-03-11 23:59:59' UNION all select uf,datahora,nomepcd from pcdmet_2003_96 cross join gestpcd_2 where pcdmet_2003_96.nomepcd=32766 and gestpcd_2.id=32766 and datahora between '1996-03-11 00:00:00' and '1996-03-11 23:59:59' order by datahora ASC