lease_tbl.end_date vs organization.lease_end_date vs organization.EndContractDate Data does not match. Some end_date values in lease_tbl match org.lease_end_date, BUT some match org.EndContractDate ELECT org.id, lt.end_date, org.lease_end_date, org.EndContractDate, org.org_name FROM `lease_tbl` lt INNER JOIN organization org ON org.id = lt.lease_org_id WHERE lt.lease_org_id IN(4, 7, 17, 25, 18);