Max of three different tables

[ju sa]

I have three tables (joined) with a number of conditions and would also like to have a contition on maximum value for three different tables

Select XX.x, YY.y, ZZ.z, WW.w
from XX 
Join YY on XX.x = YY.y
Join ZZ on YY.ya = ZZ.z And XX.x = ZZ.zb
Join WW on WW.w = ZZ.zc
where x = 'my_id'
--- How can I and do this??? 
---- max (XX.x_date, YY.y_date, ZZ.c_date) dat
and dat < somedate
and dat > some_otherdate

[Rabbit]

I have no idea what you're trying to do. A clearer explanation along with sample data and results would help.

[DURGAPRASAD51]

I THINK THIS IS WHAT U R TRYING FOR

 SELECT * FROM
           ( Select XX.x, YY.y, ZZ.z, WW.w,GREATEST(XX.x, YY.y, ZZ.z, WW.w) DAT 
from XX 
Join YY on XX.x = YY.y
Join ZZ on YY.ya = ZZ.z And XX.x = ZZ.zb
Join WW on WW.w = ZZ.zc
where x = 'my_id') DU WHERE  DU.dat < somedate and DU.dat > some_otherdate