Return largest value of two columns in the same row

• OleHank

  SSChasing Mays

  Points: 654

  More actions

  June 27, 2008 at 3:31 am

  #75250

  Ho,

  I have two date fields in my table. I want to update a control table for each customer, using whichever date is later.

  Can I achive this ? Sort of like this:

  update tableb

  set controldate = select MAX( date1 OR date2 *whichever later*) from tablea

  where tableb.customer = tablea.customer

  so I want the max date over the two columns. Hope I am making sense!!

  Can anyone help please?

  Thanks

• karthik M

  One Orange Chip

  Points: 29139

  More actions

  June 27, 2008 at 3:58 am

  #835236

  Please don't post the same question twice.

  karthik