>

SELECT max(date) as 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

MartinaJ

>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