有两张表 取某字段Z大值

select xxsupplyid，max(appdate) appdate
from (
select xxsupplyid，appdate
from
LIMS_Buy_AppList_Normal
union
select xxsupplyid，appdate
from
LIMS_Buy_AppList_Standard
) a
group by xxsupplyid