在具有两个不同表的多个列上选择distinct

Question

I have the following query below and it's selecting duplicate values from the database.

Is it possible to apply a distinct selection on multiple columns from two different tables?

SELECT m.ds_nome, a.cd_veiculo, a.dt_ini, a.dt_fim, a.cd_alerta, a.cd_motorista, a.ds_trata 
FROM alertas_jor AS a, motoristas AS m 
WHERE a.cd_motorista = m.cd_motorista AND m.cd_clifor IN(162) AND a.cd_tipo = 1

UNION

SELECT m.ds_nome, a.cd_veiculo, a.dt_ini, a.dt_fim, a.cd_alerta, a.cd_motorista, a.ds_trata 
FROM alertas_jor_hist AS a, motoristas AS m 
WHERE a.cd_motorista = m.cd_motorista AND m.cd_clifor IN(162) AND a.cd_tipo = 1