thanks for that, but that will add a row as opposed to updating a column won't it? I don't want to insert a new row. All I want to do is update a value in table1 if it is present in table2
cheers Rich >From: "DL Neil" <[EMAIL PROTECTED]> >Reply-To: "DL Neil" <[EMAIL PROTECTED]> >To: "Richard Dobson" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> >Subject: Re: update from table x to table y >Date: Tue, 13 Nov 2001 11:45:45 -0000 > > > Hi does anyone know of a way of taking some data from one table and >updating > > another table with it? > > > > If MySQL doesn't support it i'm gonna have to go back to Access or > > something! > > >Rich > >=only "go back" to Access if you're a glutton for punishment! > >=try MySQL/HTMLmanual/manual_Reference.html#INSERT_SELECT > >=dn > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php