Hi,
I am using the following query to retrive the maximum date from two tables(emp1 and emp2) againest a emp_no.

select emp_no,max(lut) from (
select emp_no,lut from emp1
union
select emp_no,lut from emp2
)
group by emp_no


Is there any better way of writing this query.
I am exploring the possibility of eliminating the UNION