Re: Help With Another UPDATE Query Please!

I am using mySQL 3.23 Each project has a work type associated with it, currently the Work Type column of the Project table holds the work type name, however i have now added a Work_Type_ID column to the Work_Type table and i would like Projects to hold the Work_Type_ID as opposed to the Work Type Name. Thanks for your help "Jeff Shapiro" <lists@nensha.com> wrote in message news:20031004070753406637.GyazMail.lists@nensha.com... > > It all depends on what database server (and version) you are using. I'm > not really sure what you are asking, and could use a little more detail > about the tables and what are needing to do. > > On Sat, 4 Oct 2003 13:45:56 +0100, Shaun spoke thusly about [PHP-DB] > Help With Another UPDATE Query Please!: > > Hi, > > > > I am making some alterations to my Database. I have a table called projects > > and a table called Work_Types. Projects currently contains the name of the > > work type (Work_Type) but now I want to change this so it contains the > > Work_Type_ID, is it possible to update Projects with one query? > > > > Thanks for your help > > --- > Listserv only address. > Jeff Shapiro