MySQL Forums
Forum List  »  General

ignore LEFT JOIN when is a empty field, is possible?
Posted by: Alexandre Salomé
Date: July 13, 2021 04:02PM

Hello!

I am needing a little help in my code:

-----------------------------------------------

SELECT * FROM oficial.tc_devices AS d LEFT JOIN cadastro_veiculo AS f ON d.contact = f.hinova_placa

-----------------------------------------------

How I ignore / "not join" when the d.contact is empty? (because is causing a problem with bad join information? (must NOT join empty field)

I tried search on google, but I could not found the answer.

Thanks in advance

Aecs

Options: ReplyQuote


Subject
Written By
Posted
ignore LEFT JOIN when is a empty field, is possible?
July 13, 2021 04:02PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.