Hii, I have the next query with left join:
select c.address, c.name, IsNull(b.validate, "No exist") from contracts as c LEFT JOIN cms__bills as b ON c.id=b.contract_id
Some rows show me null of course. But IsNull function not working. IFNULL either. How function can I use to replace?