create sql str with special condition

• armm1388

  SSC Eights!

  Points: 808

  More actions

  March 22, 2013 at 11:02 am

  #74173

  create sql str with special condition

  hellow

  I have 2 table

  Table a(code, price, check)

  Table b(code, percent)

  I want to create a sql string such below:

  Select a.code, a.price, (price * percent) as new_field

  From a,b

  Where a.code = b.code

  And this condition must be consider in sql str:

  If (check = 1)

  {

  New_field = price * percent

  }

  Else

  {

  New_field = price * percent * 8

  }

  Now how can put above condition in sql str?

  Thanks very much

• handkot

  SSCertifiable

  Points: 5273

  More actions

  March 26, 2013 at 12:23 am

  #1600614

  Select a.code, a.price, (price * percent * case when check = 1 then 1 else 8 end) as new_field

  From a,b

  Where a.code = b.code

  ?

  I Have Nine Lives You Have One Only
  THINK!