select a.* from salary_detail a, new_posting_detail b where a.personal_number=b.personal_number and (b.joining_unit='' or b.joining_sub_unit='' or b.archive_date='') and a.for_month=05 and a.for_year=2026 and a.account_number!='' and a.sus_status!=4 and a.bill_category is null order by a.employee_name