Designation Employee Vacancy

select
    `tabDesignation`.name as "Designation:Link/Designation",
    `tabEmployee`.employee_name as "Employee Name",
    `tabEmployee`.name as "Employee:Link/Employee",
    if(`tabEmployee`.name is null, "Yes", "") as "Vacancy"
from `tabDesignation` left join `tabEmployee` on (`tabDesignation`.name = `tabEmployee`.designation)