subject:"Update from other table"

Re: Update from other table

2003-10-25 Thread Victoria Reznichenko

"William IT" <[EMAIL PROTECTED]> wrote: > Does MySQL support update from other table? > > I run this query and get error: > >UPDATE TableA SET Division=TableB.Division >FROM TableB >WHERE TableA.Code=TableB.Code > Since version 4.0.4 you ca

Update from other table

2003-10-24 Thread William IT

Does MySQL support update from other table? I run this query and get error: UPDATE TableA SET Division=TableB.Division FROM TableB WHERE TableA.Code=TableB.Code Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: How to update from other table?

2003-10-23 Thread Victoria Reznichenko

"William IT" <[EMAIL PROTECTED]> wrote: > I try convert this MS SQL Statement but an error occurs: > > UPDATE a SET a.ACCOUNT_CODE=b.ACCOUNT_CODE > FROM a,b > WHERE a.ACCODE=b.ACCOUNT_OLD > > Is there any syntax doing same as above? > Yes. From v4.0.4 you can do: UPDATE a, b

How to update from other table?

2003-10-23 Thread William IT

I try convert this MS SQL Statement but an error occurs: UPDATE a SET a.ACCOUNT_CODE=b.ACCOUNT_CODE FROM a,b WHERE a.ACCODE=b.ACCOUNT_OLD Is there any syntax doing same as above? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysq