CREATE ALGORITHM = UNDEFINED DEFINER = `aerion`@`localhost` SQL SECURITY DEFINER VIEW `aerion`.`vW_DeV_LoOk_vAlUe` AS SELECT `a`.`iddev_look_value` AS `iddev_look_value`, `a`.`look_value` AS `look_value`, `a`.`look_value_desc` AS `look_value_desc`, `a`.`disp_order` AS `disp_order`, `a`.`iddev_look` AS `parent_id`, `a`.`updater` AS `updater`, `e`.`emp_fnm` AS `updater_fnm`, `e`.`fullname` AS `updater_nm`, `a`.`last_updated` AS `last_updated`, IF(ISNULL(`a`.`last_updated`), 'Never', DATE_FORMAT(`a`.`last_updated`, '%m-%d-%y %h:%i %p')) AS `last_updated_fmt` FROM (`aerion`.`dev_look_value` `a` LEFT JOIN `aerion`.`vw_emp` `e` ON ((`a`.`updater` = `e`.`emp_id`)))