Relational update

• ridzuan_first

  Right there with Babe

  Points: 798

  More actions

  October 30, 2009 at 5:27 am

  #73006

  How to update via SQL 2000 if i have situation like this?

  update payment set Payment.OrderNo=Salesorder.OrderNo where

  Payment.OrderNo=Salesorder.InvoiceNumber

  Thanks for help

  Dwen

• Garadin

  One Orange Chip

  Points: 29613

  More actions

  October 30, 2009 at 7:42 am

  #1073127

  That's an interesting update. I'd make sure that this was right, but here is how you'd write that:

  UPDATE P

  SET OrderNo = S.OrderNo

  FROM Payment P

  INNER JOIN SalesOrder S ON P.OrderNo = S.InvoiceNumber

  Seth Phelabaum

  ---

  Consistency is only a virtue if you're not a screwup. 😉

  Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]