select values from tables

Question

Hi,

 

   select min(col1),max(col1) from 

( 

    select min(col1),max(col1) from table1

    union all

    select min(col1),max(col1) from table2

)

 

  This query shows some syntax error while execute

  Let me know what I have missed with !

 

Thanks

Sathish