Sir I am using these codes

SELECT data.date
from (
select max(date)as date from crprp
union all
select max(date)as date from pouring
union all
select max(date)as date from product
) as data
group by data.date

It displays 2 different dates shown in attachment but I need only one data that is maximum DATE from 3 tables.

Please help