SELECT @last_expired_date = MAX(expired_license_date) FROM entrepreneur RIGHT OUTER JOIN Firm_info ON entrepreneur.entre_ID = Firm_info.entre_ID RIGHT JOIN Section ON Firm_info.Section_ID = Section.Section_id RIGHT JOIN license ON Firm_info.firm_no = license.firm_no RIGHT JOIN license_operations ON license.license_serial = license_operations.license_serial WHERE Section.Section_id = @section_no GROUP BY license.license_serial
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)