How do you write this SQL statement?

• jruiseco

  SSC Enthusiast

  Points: 162

  More actions

  January 16, 2002 at 3:24 pm

  #77928

  I have two tables (see below). Table 'csv' has the data I want to put into Table 'item'.

  How do I write the SQL statement (for Access) to update item.Manufac with the data in csv.Manufac? I've started out with something like this:

  update item

  set item.manufac = csv.Manufac

  where item.ItemNo = csv.itemNo

  <!-- Table Example -->

  csv.ItemNo csv.Manufac

  1234 1

  1235 3

  1236 4

  1237 9

  1238 3

  1239 1

  item.ItemNo item.Manufac

  1234 0

  1235 0

  1236 0

  1237 0

  1238 0

  1239 0

  Edited by - jruiseco on 01/16/2002 4:15:25 PM

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  January 16, 2002 at 4:36 pm

  #422259

  UPDATE Item

  INNER JOIN CSV

  ON Item.ItemNo = CSV.ItemNo

  SET Item.Manufac = [csv].[Manufac];

• jruiseco

  SSC Enthusiast

  Points: 162

  More actions

  January 17, 2002 at 7:15 am

  #422276

  Excellent.. thank you very much.