get the maximum value from a query with a join

• Hector Angello Silva Carmona

  SSCrazy

  Points: 2720

  More actions

  August 31, 2007 at 10:59 am

  #373724

  friends i need to get the maximum value from a query which is composed with a join

   

  example

  select    max (   select data from tableA

                      union all

                      select data from tableB )

   

  if i will use the query like this it casts error

  is possible to do that anyway?

  Thanks for your helping

• Mark Shvarts 1

  SSCertifiable

  Points: 5702

  More actions

  August 31, 2007 at 11:56 am

  #730851

  You may try the following:

  select max(data)

  from

  (

  select data from tableA

  union all

  select data from tableB

  )t

• Hector Angello Silva Carmona

  SSCrazy

  Points: 2720

  More actions

  August 31, 2007 at 12:07 pm

  #730855

  Excellent thank you