How do you write this SQL statement?

• jruiseco

  SSC Enthusiast

  Points: 192

  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:

  updateitem

  setitem.manufac = csv.Manufac

  whereitem.ItemNo = csv.itemNo

  <!-- Table Example -->

  csv.ItemNocsv.Manufac

  12341

  12353

  12364

  12379

  12383

  12391

  item.ItemNoitem.Manufac

  12340

  12350

  12360

  12370

  12380

  12390

  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: 192

  More actions

  January 17, 2002 at 7:15 am

  #422276

  Excellent.. thank you very much.