Re: ignore LEFT JOIN when is a empty field, is possible?

[Peter Brawley]

Assuming d.contact is a string, is this what you mean?

SELECT *
FROM oficial.tc_devices AS d
LEFT JOIN cadastro_veiculo AS f ON d.contact = f.hinova_placa
WHERE !ISNULL(d.contact) AND d.contact <> ""
ORDER BY 1;

If d.contact is default null or numeric, omit ...AND d.contact <> ""...

I added a rudimentary Order By clause because otherwise row order in the resultset would be arbitrary.